Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
(my)SQL Filtering
Hi Guys, Thanks for the help. Until earlierly mentioned, GROUP BY was missing from my SQL vocabulary. I was looking for a way to do the same thing as what 'group by' does, which is the summarising of records. The alternative was to use sub queries in a complex query, but thanks 2 u guys, there... -
(my)SQL Filtering
Hi Guys, Lets say I have two fields in a Database (DB1): ------------------- Field1(txt) | Field2(txt) a | x b | x c | y d | y e | Z I need to SELECT * FROM DB1 (where 1x(field2 = field2)) The above into words, would mean, i'd...
