As400 Help

[pea333nut]

I need to make a query that that will show all of the customers that an employee in the last year. I set the date greater than 4-01-03 and the employeeNum = to thier number. I get all of the customers that the employee had in the last year but I get duplicates. How do I make it so I only get 1 customer and no duplicates.

Thanks

 

[Rockn]

YOu need to add grouping to your query. It will always bring in duplicates the way you made your query because most have probably had more than one customer in that time frame.

 

[pea333nut]

what do you mean by add grouping. Can you give me an example!

 

[Rockn]

SELECT fieldname FROM tablename GROUP BY fieldname

 

[pea333nut]

What query definition is this under. This is on an AS400 not SQL or something else.

 

[Rockn]

Hey, you tell me! SQL is pretty much SQL anywhere you go with minor syntax differences. What database are you running?

 

[pea333nut]

I'm just not sure what option to go into to write a statement like the one you supplied. Attached is a print screen. Can you tell me where I would go to write that kind of query statement.

Thank you very much

 

[Rockn]

You still have not told anyone what type of database or program this is. A little infirmation like that would go a long way in helping you out.

 

[angel]

Not sure if this will help or not...
http://www.hcc.cc.fl.us/faculty/tom_mccullough/cgs1062/Chapter14.pps
http://www.hcc.cc.fl.us/faculty/tom_mccullough/cgs1062/Chapter15.pps