How to loop

T

Tony WONG

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
 
B

bregent

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,483
Members
44,901
Latest member
Noble71S45

Latest Threads

Top