> If this needs to give you this result: > > > > +------------+----------+--------------------+-------------------+---------- > -----+ > > | invoice_id | order_id | invoice_journal_id |invoice_timestamp | > invoice_total | > > > +------------+----------+--------------------+-------------------+---------- > -----+ > > | 1062 | 1035 | 6 | NULL | NULL | NULL | > > | 1063 | 1036 | 6 |..more NULL ... > > | 1064 | 1037 | 8 | > > | 1065 | 1038 | NULL| 1144744655 | 777 > | > > then a UNION is the only thing you can do. It's not a JOIN at all. Oh wait, > you can call it a FULL JOIN, which simply returns results from both tables > in the join, but hey, that's actually the "lack of a join", IMO :-)
Yeah, I guess a FULL one is exactly what I think I'm looking for. Still can't work the query out though, since both columns have different column lengths MySQL is complaining - I need to know how to NULL the non-existant table columns for the rows that doesn't have any values for them. Any hints? ;-) -- Kim Christensen [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]