• 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