I have a situation where I need to always get a row returned even if no match
is in the table (only 1 or many rows are acceptable).
I can use:
select a, b, c from mytable where a = 'yarp';
and might get 20 rows if there are matches, but I at least need 1 default row
back...
using :
select
Cantwell, Bryan wrote:
I have a situation where I need to always get a row returned even if no match
is in the table (only 1 or many rows are acceptable).
I can use:
select a, b, c from mytable where a = 'yarp';
and might get 20 rows if there are matches, but I at least need 1 default row
On Wed, 16 Dec 2009 07:39:09 Cantwell, Bryan wrote:
I have a situation where I need to always get a row returned even if no
match is in the table (only 1 or many rows are acceptable).
I can use:
select a, b, c from mytable where a = 'yarp';
and might get 20 rows if there are matches, but I