Post reply

How to display 3 columns from different table into one query

  • November 19, 2008 at 11:44 pm

    #900894

    Hi Arnold,

    Why won't u trying the solution of Rosh (i.e. INNER JOIN)? It gives the same output as per your requirement.

    Also, INNER JOIN is in general faster than other methods.

  • November 20, 2008 at 9:25 am

    #901123

    SELECT a.widthdata AS col1,

    b.widthdata AS col2,

    c.widthdata AS col3

    from dimlab1 a

    inner join dimlab2 b

    on a.idno = b.idno

    inner join dimlab3 c

    on b.idno = c.idno

    This is the one I tried, it works.

    I am learning too.

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

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