CODEWITHSUNDEEP
postgresql
user2594853
user2594853

Reputation: 77

Joins in postgresql

How do you change this Oracle sql to postgresql

SELECT prd.name, pkg.name, si.name 
FROM service_items si, service_link sl, products prd, packages pkg, product_package_link ppl 
WHERE ppl.id='3' 
AND prd.id=ppl.product_id
AND pkg.id=ppl.package_id AND sl.product_package_id(+)=ppl.id AND si.id(+)=sl.service_item_id
 ;

Upvotes: 1

Views: 68

Answers (1)

peterm
peterm

Reputation: 92845

Try

SELECT prd.name, pkg.name, si.name 
  FROM products prd JOIN product_package_link ppl
    ON prd.id = ppl.product_id JOIN packages pkg
    ON pkg.id = ppl.package_id LEFT JOIN service_link sl
    ON ppl.id = sl.product_package_id LEFT JOIN service_items si
    ON si.id  = sl.service_item_id
 WHERE ppl.id = '3'

Upvotes: 1

Related Questions