Hi,
i hava query, which gives the multiple keys.
select patient_key from patient where identifier='1234';
which gives N keys like bellow:
1JR7190Q3N0170760,
1JTC04146R0883050,
1JU40912IO0583050
and so on.
i have to pass these n keys as the parameter in another query.
select scanid from ScanAnalysis a where a.patient_key in(all the N keys )
i can hardcoded these values in (), but i want it parameterize N keys.
not hardcoded values, N parameter it has to take.
Thnaks,
krishna
|
|
select scanid from ScanAnalysis a where a.patient_key in ( select patient_key from patient where identifier='1234');
|
Main
webmaster@hxtt.com