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

Reply via email to