Database

seelct * from systables

SELECT Num_key, Lis_key
FROM [Table 2]
WHERE NOT EXISTS
(SELECT TOP 1 *
FROM [Table 1]
WHERE Num_key = [Table 2].Num_key
AND Lis_key = [Table 2].Lis_key)

select IsNull(a.Lis_key, b.Lis_key) as Lis_key,
    IsNull(a.Attrib_code, b.Attrib_code) as Attrib_code,
    case
        when a.Lis_key is null then 'New entry in Table2'
        when b.Lis_key is null then 'New entry in Table1'
        else 'Identical'
    end as MatchComment
from Table1 as a
full outer join Table2 as b
on a.Lis_key = b.Lis_key
and a.Attrib_code = b.Attrib_code

select exchange_id, trade_date, trade_time, 
	short_name, code_buy, 
	capacity_buy, code_sell, 
	capacity_sell, trade_price, 
	trade_size, trade_type, 
	cancelled, quarter_percent_true
	from trades t, reports r
	where trade_price > 
		(select 1.02 * AVG(trade_price) 
		from trades 
		where isin = t.isin and trade_date = @trade_date
		group by isin)
	and trade_date = @trade_date
	and t.isin = r.ti_code
	and r.case_owner = @case_owner
	and r.run_rylat = 'YES'
	and t.cancelled = 'N'
	order by short_name, trade_price DESC