Hi
You can try like this. i guess it will solve your problem
select distinct a.* from INFORMATION_SCHEMA.COLUMNS a
where a.column_name not in (select column_name from INFORMATION_SCHEMA.COLUMNS b
where b.table_name in ('stp_rule_dtl') ) ---- Table A
and a.table_name in ('stp_rule_esc_dtl') --- Table B
order by a.column_name
Thanks
jaypee.s