Hi to All, I've been a member of this mailing list for quite a long time and very thankful that most of my difficulty in creating queries are being answered by just reading responses to questions. Right now I have a problem in creating a query (in fact I'm not sure if this is possible) that will get data from two tables and display its row from one table followed by the same row number of the other table.
Table1 col_1 col_2 col_3 col_4 A A A A A A A A A A A A A A A A A A A A A A A A A A A A . . . Table2 col_1 col_2 col_3 col_4 B B B B B B B B B B B B B B B B B B B B B B B B B B B B . . . Query result col_1 col_2 col_3 col_4 A A A A B B B B A A A A B B B B A A A A B B B B A A A A . . . I will really appreciate any of your help in accomplishing this. Thanks in advance, Richard [This e-mail is confidential and may also be privileged. If you are not the intended recipient, please delete it and notify us immediately; you should not copy or use it for any purpose, nor disclose its contents to any other person. Thank you.] --------------------------------------------------------------------- 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