Re: Probably a newbie question

[Melvin Davidson <melvin6925@xxxxxxxxx>]

>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 <robjsargent@xxxxxxxxx> 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!