Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › MySQLi Server Behaviors › Query Builder › How to return a recordset with multiple JOINS where a row may not exist in a table

View all replies to this thread

How to return a recordset with multiple JOINS where a row may not exist in a table

Thread began 2/24/2023 6:51 am by Jared Lui | Last modified 2/28/2023 12:11 pm by Jared Lui | 452 views | 1 replies

2/28/2023 12:11 pmRay BorduinWebAssist

It is probably just a matter of getting your table order and join types set up correctly. For instance I think this one might be:

$rsLots->setQuery(" SELECT * FROM users LEFT OUTER JOIN lotOwners ON lotOwners.ownerID = users.UserID LEFT OUTER JOIN lots ON lots.lotNumber = lotOwners.lotNumber WHERE userID = ?");

The left outer join will return all of the rows from the table on the left even if there are no matching rows in the table to the right. I think that is the key to your problem if I'm understanding it right.

Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.