Re: Probably a newbie question

2019-08-11 Thread stan
On Sat, Aug 10, 2019 at 02:57:14PM -0400, stan wrote: > Sorry, I got the list address wrong the first time, and when I corrected it, > I forget to fix the subject line. > > I apologize for asking, what I suspect will turn out to be a newbie > question, but I have managed to get myself quite

Re: Probably a newbie question

2019-08-10 Thread David G. Johnston
On Saturday, August 10, 2019, stan wrote: > Sorry, I got the list address wrong the first time, and when I corected it, > I forget to fix the subject line. > > This subject line isn’t materially better...subjects should reflect the technical content of the message, not its sender. David J.

Re: Probably a newbie question

2019-08-10 Thread Melvin Davidson
>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 wrote: > > > I'd look here: > > SELECT > name > FROM >

Re: Probably a newbie question

2019-08-10 Thread Rob Sargent
> > I'd look here: > > SELECT > name > FROM > vendor > WHERE > bom_item.vendor_key = > ( > SELECT > vendor_key > FROM >

Re: Probably a newbie question

2019-08-10 Thread Ron
On 8/10/19 1:57 PM, stan wrote: Sorry, I got the list address wrong the first time, and when I corected it, I forget to fix the subject line. I apologize for asking, what I suspect will turn out to be a newbie question, but I have managed to get myself quite confused on this. I am defining a

Probably a newbie question

2019-08-10 Thread stan
Sorry, I got the list address wrong the first time, and when I corected it, I forget to fix the subject line. I apologize for asking, what I suspect will turn out to be a newbie question, but I have managed to get myself quite confused on this. I am defining a view as follows CREATE OR REPLACE