I'm a bit new to this, so bear with me if it seems obvious. :)
I have two tables the content of which I'd like to display in a single result, ordered by content of fields that have similar content but different names in the two tables. This is as far as I've gotten: SELECT invoice.invdate AS date, invoice.invnum AS comment, invoice.amount, receivable.date, receivable.itemnumber AS comment, -receivable.amount FROM invoice LEFT JOIN receivable USING (custid) WHERE invoice.custid='someconstant' AND receivable.custid=invoice.custid ORDER BY date; This (perhaps obviously) doesn't work, giving me a six-column output with content of 'receivable' *beside* 'invoice' instead of being intermixed with it. The result I WANT would have three columns, giving me a "statement" with both credits and debits to an account. All in all, it looks pretty much identical to: SELECT invoice.invdate AS date, invoice.invnum AS comment, invoice.amount, receivable.date, receivable.itemnumber AS comment, receivable.amount FROM invoice,receivable WHERE invoice.custid='someconstant' AND receivable.custid=invoice.custid ORDER BY date; I'm obviously on the wrong track. Is UNION what I want to be using here? Thanks. -- Paul Chvostek <[EMAIL PROTECTED]> --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php