MrLarkins.com Posted October 13, 2006 Share Posted October 13, 2006 ok, i think i know the answer hereif 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? Link to comment https://forums.phpfreaks.com/topic/23874-joining-tables-side-effect/ Share on other sites More sharing options...
fenway Posted October 13, 2006 Share Posted October 13, 2006 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". Link to comment https://forums.phpfreaks.com/topic/23874-joining-tables-side-effect/#findComment-108562 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.