How to loop

Discussion in 'ASP General' started by Tony WONG, Nov 18, 2005.

  1. Tony WONG

    Tony WONG Guest

    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
    Tony WONG, Nov 18, 2005
    #1
    1. Advertising

  2. Tony WONG

    bregent Guest

    In article <ehB#k8#>, 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.
    bregent, Nov 18, 2005
    #2
    1. Advertising

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?VGltOjouLg==?=

    Loop the loop...

    =?Utf-8?B?VGltOjouLg==?=, Feb 16, 2005, in forum: ASP .Net
    Replies:
    2
    Views:
    1,381
    Karl Seguin
    Feb 16, 2005
  2. Steven

    while loop in a while loop

    Steven, Mar 24, 2005, in forum: Java
    Replies:
    5
    Views:
    2,230
    Tim Slattery
    Mar 30, 2005
  3. -
    Replies:
    12
    Views:
    692
    Remon van Vliet
    Jun 15, 2005
  4. Byte
    Replies:
    4
    Views:
    415
  5. Isaac Won
    Replies:
    9
    Views:
    372
    Ulrich Eckhardt
    Mar 4, 2013
Loading...

Share This Page