|
redbrad0
Advanced Member
USA
3725 Posts |
 Posted - 27 August 2003 : 21:18:42
|
I am having a hard time with a SQL Query. Instead of pasting the entire long query I will just explain. My SQL Statment combines 5 tables that are all INNER JOINED. With 13 different columns out of the 5 databases returned when I try to group them by the main tables ID I still get duplicate records that just have other tables data that match the critia that are linked to the main record. How can I get it to group by the ID column? I have...
GROUP BY ID, COLUMN2, COLUMN3, COLUMN4, COLUMN5
But it just doesnt group everything by the ID, any ideas or suggestions? |
Brad
Oklahoma City Online Entertainment Guide
Oklahoma Event Tickets |
|
Topic Locked
