Re: A JOIN question

2019-12-30 Thread stan
On Mon, Dec 30, 2019 at 02:47:53PM -0700, Michael Lewis wrote: > > > > LEFT join mfg_vendor_relationship on > > mfg_vendor_relationship.mfg_key = mfg_part.mfg_key > > AND > > mfg_vendor_relationship.project_key = bom_item.project_key > > LEFT join vendor on > > mfg

Re: A JOIN question

2019-12-30 Thread Michael Lewis
> > LEFT join mfg_vendor_relationship on > mfg_vendor_relationship.mfg_key = mfg_part.mfg_key > AND > mfg_vendor_relationship.project_key = bom_item.project_key > LEFT join vendor on > mfg_vendor_relationship.vendor_key = vendor.vendor_key > Perhaps I am missing som