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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by railboy
-
4 tables - subqueries or joins
Still don't think that this solution works, but I just wanted to point out that subequeries don't work for me as the version of MySQL is 4.0.15 and subqueries are supported from version 4.1 upwards. -
4 tables - subqueries or joins
Thanks ggggus but I don't think he query is correct, when I test it on my data I get an agent appearing and he shouldn't as he has several contacts subscribed to that list (mailinglist '1' in your example). -
4 tables - subqueries or joins
Hi I would really appreciate some help on this one as I've tried various methods and can't get this to work on MySQL. Any ideas anyone ? I have 4 tables: agents, contacts, subscription, mailinglists agents ID_AGENT int(11) 0 NAME...
