> > Note that my example is not a realy result set, it's only here to show > > you what kind of query I'm trying to build! > > Yes, that I understand. But WHAT is your current data in both tables > from which you can/should derive your wanted resultset?
invoice_archive: +------------+----------+--------------------+ | invoice_id | order_id | invoice_journal_id | +------------+----------+--------------------+ | 1062 | 1035 | 6 | | 1063 | 1036 | 6 | | 1064 | 1037 | 8 | +------------+----------+--------------------+ invoice: +------------+----------+-------------+-------------------+---------------+ | invoice_id | order_id | customer_id | invoice_timestamp | invoice_total | +------------+----------+-------------+-------------------+---------------+ | 1065 | 1038 | 63 | 1144744655 | 777 | +------------+----------+-------------+-------------------+---------------+ I hope this helps, sorry for being short on information but I haven't really woken up properly yet. More coffee.. -- Kim Christensen [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
