G'day Nils Well, I can't speak for Daniel, and I'm not really up on his tables, but I'm not using left joins. The situation I have is not one where I need to display items that don't exist from one table or another.
The data I get from a basic join is the _data_ I want - I just can't get it to display in a clear fashion. The join is forcing 'extra' superfluous data to be displayed. I know this could be eliminated if I could obtain all the data for a union, but I can't see a way to display as a union and query as a join. cheers kim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
