• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
SQL Join

#4
[eluser]Randy Casburn[/eluser]
Right. You'll need to accomplish an OUTER join for this. An OUTER join SELECTs a portion of one result set (in your case it is the set of feeds "saved" by this "userID") while SELECTing an entire result set from another source (in your case this would be the whole set of available feeds whether "saved" or "unsaved" by any "userID").

Whether it is a "righty" or a "lefty" OUTER join simply depends on which table you put on the left or right in the select statement.

Go back and put together a RIGHT OUTER join with the feed table as the "righty" and I think you'll be happy.

Randy

[EDIT] - had to edit this for fear of getting a back wash from the more astute crowd of very smart folks here. Mathmatically speaking, Dr. Codd would be very displeased as I did not digress into Set Theory in the explanation about the OUTER JOIN. Suffice it to say you can blog about that and I acknowledge my poor layman's explanation Tongue


Messages In This Thread
SQL Join - by El Forum - 08-21-2008, 07:35 AM
SQL Join - by El Forum - 08-21-2008, 08:11 AM
SQL Join - by El Forum - 08-21-2008, 08:27 AM
SQL Join - by El Forum - 08-21-2008, 09:55 AM
SQL Join - by El Forum - 08-21-2008, 10:23 AM
SQL Join - by El Forum - 08-21-2008, 10:48 AM
SQL Join - by El Forum - 08-21-2008, 01:03 PM
SQL Join - by El Forum - 08-21-2008, 01:32 PM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.