Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: How can I avoid the "Single row subquery returns more than one row" message
Could you not try:
SELECT COLUMN
FROM TABLE_A
WHERE COLUMN IN (SELECT TABLE_B.COLUMN
FROM TABLE_B WHERE (join sub-query to query) ??
Sj
<joelsung_at_my-deja.com> wrote in message news:8dg1cl$lt8$1_at_nnrp1.deja.com...
> Try using "ANY" in front of your sub-query.
>
> SELECT COLUMN
> FROM TABLE_A
> WHERE COLUMN = ANY(SELECT TABLE_B.COLUMN
> FROM TABLE_B
> WHERE (join sub-query to query)
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Apr 19 2000 - 00:00:00 CDT