Hi TOM,

First of all, Thank you very much for helping the Oracle community. Well, I write SQL queries, but they are limited to entry level only. My question is related with UNION. Below is my SQL query. It works fine, but I am struggling to find a better solution than using UNION.

--##################################################################################################################################
select * from TEST_TABLE tst_table where tst_table.access = 'PUBLIC' AND tst_table.company='X'
UNION
select * from TEST_TABLE tst_table where tst_table.access = 'PRIVATE' AND tst_table.owner='joe'
UNION
select * from TEST_TABLE tst_table where tst_table.access = 'EXECUTIVE' AND tst_table.role='EXECUTIVE_ROLE' AND tst_table.company='X'
--##################################################################################################################################

access, company, owner, role are columns in TEST_TABLE.

Any better solution with respect to best practice to fetch same results WITHOUT using UNION.

Thank you in advance,
Raj.

select * from TEST_TABLE tst_table 
where ( tst_table.access = 'PUBLIC' AND tst_table.company='X' )
or ( tst_table.access = 'PRIVATE' AND tst_table.owner='joe' )
or ( tst_table.access = 'EXECUTIVE' AND tst_table.role='EXECUTIVE_ROLE' AND tst_table.company='X' )