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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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... -
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...
