non-duplicate data from 2 seperate tables help

[killswitch101]

I need to get all of the non-duplicate data out of 2 tables (ci and hi)
i can't seem to work it out
i think i need to use the minus command but that will only display the data for 1 table
can anyone help

[amitpatel66]

I need to get all of the non-duplicate data out of 2 tables (ci and hi)
i can't seem to work it out
i think i need to use the minus command but that will only display the data for 1 table
can anyone help

Could you please post what you have tried so far?

[killswitch101]

select
from ci
minus
select
from hi;
so far ive tried that but it only shows the data from ci and not hi like i want it to

[amitpatel66]

select
from ci
minus
select
from hi;
so far ive tried that but it only shows the data from ci and not hi like i want it to

Try this:

[code=oracle]

select * from ci
UNION
select * from hi

[/code]