CountryGirl Posted January 27, 2010 Share Posted January 27, 2010 I have 6 tables joined into my search at the moment. There are two more tables that I need to join in, but everytime I try to join them in, nothing will pull up. I should still be able to pull information up. And, if that particular record doesn't have anything in it for let's say the "Commercial improvement" row, it'll just be blank. But, all the other information and rows will have the adequate information in them. But, nothing pulls up. It just returns the row titles with no data under them. It's just with these two particular tables. Why would it be doing this? There's nothing different in the format of these two tables compared to the other tables. They are all still joined by the same thing - Account number. Any thoughts as to why I can't get these tables to return results? Qadoshyah Link to comment https://forums.phpfreaks.com/topic/190012-why-cant-i-pull-data-from-certain-tables/ Share on other sites More sharing options...
Mchl Posted January 27, 2010 Share Posted January 27, 2010 For tables where column may be blank use LEFT JOIN instead of INNER JOIN Link to comment https://forums.phpfreaks.com/topic/190012-why-cant-i-pull-data-from-certain-tables/#findComment-1002509 Share on other sites More sharing options...
CountryGirl Posted January 27, 2010 Author Share Posted January 27, 2010 Thanks, that worked! I didn't even think of trying a different join . Qadoshyah Link to comment https://forums.phpfreaks.com/topic/190012-why-cant-i-pull-data-from-certain-tables/#findComment-1002521 Share on other sites More sharing options...
Mchl Posted January 27, 2010 Share Posted January 27, 2010 http://en.wikipedia.org/wiki/Join_%28SQL%29 http://www.codinghorror.com/blog/archives/000976.html <--- good one (just remember there's no FULL OUTER JOIN in MySQL) Link to comment https://forums.phpfreaks.com/topic/190012-why-cant-i-pull-data-from-certain-tables/#findComment-1002523 Share on other sites More sharing options...
CountryGirl Posted January 27, 2010 Author Share Posted January 27, 2010 http://en.wikipedia.org/wiki/Join_%28SQL%29 http://www.codinghorror.com/blog/archives/000976.html <--- good one (just remember there's no FULL OUTER JOIN in MySQL) Thanks, I'll keep those links handy!! Qadoshyah Link to comment https://forums.phpfreaks.com/topic/190012-why-cant-i-pull-data-from-certain-tables/#findComment-1002526 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.