Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

need to check 3 columns of a table with one value getting from another table . how will be the query

elegantbuddySep 14 2014 — edited Sep 28 2014

select * from sup_inv_table where ( acct_m_ser_no_jv,acct_m_ser_no_ej,acct_m_ser_no_pc) in (select acct_m_ser_no,acct_m_ser_no,acct_m_ser_no from  acct_d where acct_code='1405')


got result with following query


select * from sup_inv_table where  acct_m_ser_no_jv in (select acct_m_ser_no from  acct_d where acct_code='1405')

or  acct_m_ser_no_ej in (select acct_m_ser_no from  acct_d where acct_code='1405')or acct_m_ser_no_pc in (select acct_m_ser_no from  acct_d where acct_code='1405')


suggest another way
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 26 2014
Added on Sep 14 2014
3 comments
1,174 views