What i want to do seems simple, but i can not for the life of me figure out how to do it. Tables: These tables are not related in any way.
A -- 1 2 3 4 5 B -- 1,Bob 3,Jack 7,Janet 8,Gary 9,Kelly I would like to combine tables A and B with a SELECT statement to get this: SELECT ------ 1,1,Bob 2,3,Jack 3,7,Janet 4,8,Gary 5,9,Kelly So basically i want to join two tables, but i dont have anything to match on...Basically, i am trying to take a column from one table and add it to another table for a SELECT statement. I am not sure if JOIN is even what i am looking for here. To do this, i am assuming both tables have the exact same number of records. Any ideas on how i can do this? Thanks, Jeff SQL query _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. --------------------------------------------------------------------- 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
