Post reply

sub query to join

  • November 7, 2011 at 8:59 am

    #247469

    how to convert this sub query to join?

    select *

    from

    a,b,c

    where

    A.cash_id in

    ( select B.cash_id

    from B

    where B.cash_id = C.cash_id

    )

  • November 7, 2011 at 9:06 am

    #1404019

    I'm not sure if I follow you 100% but you can do

    select * from a

    inner join b on A.cash_id = B.cash_id

    inner join c on A.cash_id = C.cash_id

    hope it helps

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

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