LEFT JOIN for noobs

LEFT JOIN for noobs

El Forum
Unregistered

06-15-2009, 09:34 AM

[eluser]slowgary[/eluser]
It was actually less fields than I thought because the first table contained most of them, and I only needed 1 field from each of the other tables, so I have something like:

Code:
->select('table1.*, table2.field, table3.field')

That works like a charm. Thanks sl3dg3.

Would be nice to have a SELECT INVERT though for other cases.

Messages In This Thread

LEFT JOIN for noobs - by El Forum - 06-15-2009, 08:36 AM

LEFT JOIN for noobs - by El Forum - 06-15-2009, 09:09 AM

LEFT JOIN for noobs - by El Forum - 06-15-2009, 09:27 AM

LEFT JOIN for noobs - by El Forum - 06-15-2009, 09:34 AM

LEFT JOIN for noobs - by El Forum - 06-15-2009, 10:51 AM

LEFT JOIN for noobs - by El Forum - 06-15-2009, 05:01 PM