sql - single query to find difference in values in the three tables in oracle -

sql - single query to find difference in values in the three tables in oracle -

am having 3 similar tables

test_dev test_qmg test_prod

all tables have same columns. want single query find difference in values in 3 tables. example:

select * test_dev minus select * test_qmg minus select * test_prod

column names same 3 tables. want find difference in values in column.

select validity_days_before_entry,validity_days_after_entry visa_type_lk visa_type_id=1 select validity_days_before_entry,validity_days_after_entry visa_type_lk_qmg visa_type_id=1 select validity_days_before_entry,validity_days_after_entry visa_type_lk_prod visa_type_id=1

here validity_days_before_entry,validity_days_before_entry column change. want find difference

i believe looking for:

select dev.visa_type_id, (dev.validity_days_before_entry - qmg.validity_days_before_entry - prod.validity_days_before_entry) difference_before, (dev.validity_days_after_entry - qmg.validity_days_after_entry - prod.validity_days_after_entry) difference_after

from visa_type_lk dev inner bring together visa_type_lk_qmg qmg on dev.visa_type_id = qmg.visa_type_id inner bring together visa_type_lk_prod prod on qmg.visa_type_id = prod.visa_type_id

where dev.visa_type_id =1

here's link sql fiddle demonstrate: http://sqlfiddle.com/#!2/56e16/2

are sure want though? can't imagine how info useful. way, of these tables in 1 database, right?

sql oracle