Jump to content

Archived

This topic is now archived and is closed to further replies.

MrLarkins.com

Joining tables side effect?

Recommended Posts

ok, i think i know the answer here

if pull data from several different tables and join them by a common item, say member id, what happens when a member id doesn't have data in the second table?

Share this post


Link to post
Share on other sites
If you use an INNER JOIN, you won't get any record, since that type of JOIN requires a matching record in both tables.  If you use a LEFT JOIN, you will get back all records from the table on the "left", and NULLs for the requested columns from the table on the "right".

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.