On 4/11/06, Santino <[EMAIL PROTECTED]> wrote: > I do not try it : > > select invoice_id, order_id, customer_id, invoice_timestamp, > invoice_total, null > from invoice > union all > select invoice_id, null, null, null, null, invoice_journal_id > from invoice_archive
Works like a charm, thanks! -- Kim Christensen [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]