Consolidated View in Oracle

Hi all,

I want to create a consolidated view in Oracle which provides data from two tables.

If the data is present in table A then it should not be fetched from table B.
this is the only criteria.

Please could you suggest a way forward.

Thanks
Vinay

You need to create a view for the purpose based on join of both the tables

You can use anti join or minus set operator.