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!

Register Log in
  • Congratulations biv343 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: *

  1. 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.
  2. railboy

    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).
  3. railboy

    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...

Part and Inventory Search

Back
Top