Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
Which tables in the purchasing schema might be able to join, and which columns might be keys to join on?
select *
from purchasing.purchaseorderdetail
limit 10;
-- what keys might there be?
\dt purchasing.*
\d purchasing.productvendor
-- productid
-- businessentityid
\d purchasing.purchaseorderdetail
-- purchaseorderid
-- productid
\d purchasing.purchaseorderheader
-- purchaseorderid
-- employeeid
-- vendorid
-- shipmethodid
\d purchasing.shipmethod
-- shipmethodid
\d purchasing.vendor
-- businessentityid
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment