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!
Search results for query: *
- Users: spidgeon12
- Order by date
-
complex query not using group_concat for early versions of mysql
Hi, I was wondering if any body could please help me. I am trying to create a query using the following tables: Client ClientInterests Interests The client table has a clientID field etc The interest table has a interestID field etc and the ClientInterest table has the folowing fields...- spidgeon12
- Thread
- Replies: 1
- Forum: MySQL
-
alternative to group_concat for early versions of mysql
Hi, Is there an alternative to group concat, if you are using a lower version of mysql. If any one has any ideas it would be great, currently my code (thanks to some one from these forums) looks like this. SELECT c.clientID, group_concat(ci.interestID) as interests FROM Clients AS c JOIN...- spidgeon12
- Thread
- Replies: 1
- Forum: MySQL
