>ERROR: more than one row returned by a subquery used as an expression Without knowledge as to the contents of your data, the best I can suggest is to use *SELECT DISTINCT* in your subqueries.
On Sat, Aug 10, 2019 at 3:42 PM Rob Sargent <robjsarg...@gmail.com> wrote: > > > I'd look here: > > SELECT > name > FROM > vendor > WHERE > bom_item.vendor_key = > ( > SELECT > vendor_key > FROM > mfg_vendor_relationship > WHERE > bom_item.mfg_key = mfg_key > AND > prefered = TRUE > AND > bom_item.project_key = project_key > > ) > > > -- > Angular momentum makes the world go ‘round. > > > You might get away with adding > group by vendor_key > if it turns out you’re simply getting many copies of vendor key from that > inner select. > Run it alone to see. > > > -- *Melvin Davidson* *Maj. Database & Exploration Specialist* *Universe Exploration Command – UXC* Employment by invitation only!
