select  j.idx, j.userid, j.title, j.content, j.isshow, j.stridx, j.homepage, j.companyNm, t.Vndcd, c.logo from t_company_press j, table_tv t, t_customer c

where j.userid = t.customeruserid and t.vndCD = c.customerid

 

위에 쿼리를 정식으로 INNER JOIN 으로 풀게 되면, 아래와 같다.

SELECT   j.idx, j.userid, j.title, j.content, j.Isshow, j.stridx, j.homepage, j.companyNm,
                t.VndCD, c.Logo
FROM      t_company_press j INNER JOIN
                table_tv t ON j.userid = t.CustomerUserId INNER JOIN
                T_Customer c ON t.VndCD = c.Customerid