Re: [GENERAL] Subselect AS and Where clause

2011-01-26 Thread Uwe Schroeder
> Uwe Schroeder, 26.01.2011 08:34: > > I have a query like this: > > > > SELECT a,b,c, (select problem from other_table where id=a) as problem > > FROM mytable WHERE a=1 > > > > So far so good. Actually "problem" always resolves to one record, so it's > > not the "multiple records returned" pro

Re: [GENERAL] Subselect AS and Where clause

2011-01-26 Thread Sim Zacks
On 01/26/2011 09:34 AM, Uwe Schroeder wrote: Google being useless tonight - now that's new :-) What I'm trying to do is the following and I'm certain there is a simple solution which eludes me: I have a query like this: SELECT a,b,c, (select problem from other_table where id=a) as problem FRO

Re: [GENERAL] Subselect AS and Where clause

2011-01-26 Thread Thomas Kellerer
Uwe Schroeder, 26.01.2011 08:34: I have a query like this: SELECT a,b,c, (select problem from other_table where id=a) as problem FROM mytable WHERE a=1 So far so good. Actually "problem" always resolves to one record, so it's not the "multiple records returned" problem. What I try to do is thi

[GENERAL] Subselect AS and Where clause

2011-01-25 Thread Uwe Schroeder
Google being useless tonight - now that's new :-) What I'm trying to do is the following and I'm certain there is a simple solution which eludes me: I have a query like this: SELECT a,b,c, (select problem from other_table where id=a) as problem FROM mytable WHERE a=1 So far so good. Actually