Skip to Content
0

Failed to select multiple records in SQL subquery

Jul 13, 2017 at 07:15 AM

16

avatar image

Hello,

I need to know how can I modify these sub queries:

if I have ANM_NOMINEECODE not fixed for any random ACC_CODE

Currently my queries have hard coded values but I have few cases having different values other than 1 , 2 , 3

For Example :

8028 in this sample have three different nominee codes i.e. 231, 232, 233

and below is my query result for other acc_code 1931 showing nominee 1 for nominee code 1 , nominee 2 for nominee code 2 and nominee 3 for nominee code 3.

Any help would by highly appreciated.

Thanks,

Regards,

Sana

ebciz.png (15.5 kB)
uoynd.png (14.4 kB)
iz5nv.jpeg (77.7 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers