Create Procedure NoNeedForAnSP @myValue int as select TableP.*, tableX.FK, tableX.sales from tableP inner join (select * from tableA union select * from tableB union select * from tableC union select * from tableD) tableX on tableP.PK = tableX.FK where tableP.PK = @myValueBrilliant Cetin!! Thank you very much.