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 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: *

  1. lemysql

    select question

    It sounds like you want to get a name regardless of whether the person is a member or just a visitor. So, you need to get all "Grouping" records and any matching "Member" records. This requires an OUTER JOIN. The LEFT OUTER JOIN ("OUTER" is optional) gets all...
  2. lemysql

    mysql query please help

    You definitely should keep the 3 tables you have and not reduce them to 2 tables. You can get all the data you need by using either of the queries below. They both do the same thing; just different ways of going about it. SELECT a.artistname, d.cost, d.disctitle, d.releasedate, s.songtitle...

Part and Inventory Search

Back
Top