- - Code, Content, and Presentation
- -- Databases
- ---- MySQL LEFT JOIN, RIGHT JOIN AND Union ALL issues.!
syber - 9:31 pm on Aug 11, 2010 (gmt 0)
In that situation you might want to take the invoice_id match out of the ON clause in each of the queries. This way the payment information should return even if there isn't a match on invoice_id.
Thread source: http://www.webmasterworld.com/databases_sql_mysql/4180478.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com