Post reply

need to display All the column from 2 different table

  • August 13, 2012 at 7:29 am

    #280080

    Hello I need to display All the column from 2 different table for example

    table 1

    Column1 Column2 column 3

    table 2

    Column1 Column2 Column 3

    Result should be

    Column1 Column2 column 3 Column1 Column2 column 3

    table 1 has 10,000 rows and table 2 has 5000 row. so for table 2 the remaining 5000 line will be null.

    Any idea?

  • August 13, 2012 at 7:34 am

    #1525046

    Difficult to say without knowing your table structures.

    Have you looked into using a FULL OUTER JOIN?

    Cheers

    Andy

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply