Given the two tables: "fruit_table", and "vegetable_table", how do I get the "Desired ResultSet" below? Thanks...
fruit_table +---------------------+--------+ | date | fruit | +---------------------+--------+ | 2002-12-16 00:00:00 | Apple | | 2002-12-17 00:00:00 | Banana | +---------------------+--------+ vegetable_table +---------------------+-----------+ | date | vegetable | +---------------------+-----------+ | 2002-12-17 00:00:00 | Carrot | | 2002-12-18 00:00:00 | Potato | +---------------------+-----------+ Desired ResultSet +---------------------+--------+-----------+ | date | fruit | vegetable | +---------------------+--------+-----------+ | 2002-12-16 00:00:00 | Apple | | | 2002-12-17 00:00:00 | Banana | Carrot | | 2002-12-18 00:00:00 | | Potato | +---------------------+--------+-----------+ SpamFilterBuster: sql --------------------------------------------------------------------- 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