Joins in postgresql

Question

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
 ;

peterm · Accepted Answer · 2013-07-18 09:45:25Z

1

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'

answered Jul 18, 2013 at 9:45

peterm

93k16 gold badges157 silver badges162 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Joins in postgresql

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related