View previous topic :: View next topic
|
Author |
Message |
jwell rymbei
New User
Joined: 14 Dec 2005 Posts: 22 Location: India
|
|
|
|
Hi all can we use subquery to retrive multiple rows.
My query is of like this
SELECT * FROM EMP
WHERE EMP_ID = (SELECT EMP_ID FROM TEMPA
WHERE DIR_ID =
( SELECT DIR_ID FROM TDIR
WHERE DIR_CTRY_CD <> 'US'));
For the above query I am getting an sql code of -811.
Can you guyz send me some sample subquery.. |
|
Back to top |
|
|
radhakrishnan82
Active User
Joined: 31 Mar 2005 Posts: 435 Location: chennai, India
|
|
|
|
Code: |
can we use subquery to retrive multiple rows |
Yes.
Use cursor to retrieve mulitple rows.
hope this helps. |
|
Back to top |
|
|
sairam
New User
Joined: 30 Aug 2005 Posts: 58 Location: Kolkata
|
|
|
|
Hi,
try the following IN instead of '='
SELECT * FROM EMP
WHERE EMP_ID IN (SELECT EMP_ID FROM TEMPA
WHERE DIR_ID IN
( SELECT DIR_ID FROM TDIR
WHERE DIR_CTRY_CD <> 'US')); |
|
Back to top |
|
|
jwell rymbei
New User
Joined: 14 Dec 2005 Posts: 22 Location: India
|
|
|
|
Hi,
Radhakrishnan.
i need to use the query in SPUFI only..
Sairam..
I tried with IN and it worked..thanks a lot...
you r the man.. |
|
Back to top |
|
|
|