Dear experiences..
i have two tables…. A and B, where table A involves 4 columns as follow :
Table A:-
Id index con_name class1 200 greed 12 301 rfg 33 505 rft 34 401 oil 1etc..
Table B:-
con_name Var1 Var2 .......... VarNrft ............................greed ............................rfg ............................conr ...........................oil ...........................
- So ,my requirements as follow:
- i need to build dictionary table includes only (con_name) that exist in both tables A and B.. then
- remove con_name rows from Table A that not exist in dictionary table
- remove con_name rows from Table B that not exist in dictionary table
- sort con_name rows in table A and B in similar order.. where the result of table A and B shows that con_name in similar order.
i would thanks any one can help me in these requirements. thanks
Best Answer