Page is a not externally linkable
- Code, Content, and Presentation
---- MySQL LEFT JOIN, RIGHT JOIN AND Union ALL issues.!
syber - 9:31 pm on Aug 11, 2010 (gmt 0)Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4180478.htm
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.
Brought to you by WebmasterWorld: http://www.webmasterworld.com