Skip to Content

Failed to select multiple records in SQL subquery

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers