'Joining multiple tables ORACLE

SELECT *
FROM STORE
     ,MATERIAL
     ,STOREBIN
     ,VENDOR
     ,MATERIALPRICE
     ,SD
WHERE STOREBIN.STOREBINID(+) = SD.STOREBINID
AND SD.VENDORID = VENDOR.VENDORID(+)
AND MATERIAL.MATERIALID = MATERIALPRICE.MATERIALID(+)
AND STORE.STOREID = SD.STOREID

I have this simple query here, but i want to change the (+) notations into joins, how would this be possible? I was thinking:

RIGHT JOIN SD ON STOREBIN.STOREBINID = SD.STOREBINID
LEFT JOIN VENDOR ON VENDOR.VENDORID = SD.VENDORID
LEFT JOIN MATERIALPRICE ON MATERIALPRICE.MATERIAID = MATERIAL.MATERIALID
WHERE STORE.STOREID = SD.STOREID

But that hardly seems right because i need to join each table onto different tables.

sqloraclejoin


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions