ASP - How to loop

Author

How to loop

Tony WONG

2005-11-17, 9:55 pm

i have 2 tables (A & B) with date records

now i loop table A and then table B, the output will be table A in the front
and table B in the back.

how can i make the output show by date in both tables altogether?

do i need to combine tables before but the number of records is over 100K
which may spend a lot of processing power?

grateful for any hints?

thanks.

tony

bregent

2005-11-18, 6:56 pm

In article <ehB#k8#6FHA.3804@TK2MSFTNGP14.phx.gbl>, Tony WONG says...
>
>i have 2 tables (A & B) with date records
>
>now i loop table A and then table B, the output will be table A in the front
>and table B in the back.
>
>how can i make the output show by date in both tables altogether?
>
>do i need to combine tables before but the number of records is over 100K
>which may spend a lot of processing power?
>
>grateful for any hints?

You need to select from both tables at once, using a join operator. You join the
tables on the column that relate the two tables together.

Sponsored Links