How to use another query in an IN statement?

Vote count:

0

I have these query:

 Select CODE
 FROM TABLE.STATUS
 WHERE REFERENCE IN ('423',{variable})

Select Sec_Code
From Table.Sec_status
Where Sec_reference = 'ABC'

The second query returns 35 triple digit codes that I want to insert into the {variable} sections I tried :

 Select CODE
 FROM TABLE.STATUS
 WHERE REFERENCE IN ('423',(Select Sec_Code
 From Table.Sec_status
 Where Sec_reference = 'ABC'))

But that errored out. Thanks!

asked 1 min ago

Sewder

180