Table A UserName Category Raja ECE Manoj CAT Siva ENG Kumar MAT Viru WEB
Table B Name ECE MAT ROB ENG Ching 10 0 7 9 Leeng 21 2 21 2
Need Output like : UserName Category Raja ECE Siva ENG Kumar MAT
select * from tablea where category in ( select COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = 'tableb')
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)