sub query to join

• skanth

  Right there with Babe

  Points: 730

  More actions

  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

  )

• acerrover

  SSC Rookie

  Points: 26

  More actions

  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