I'm working on SQL Server 2005.
I need to compare two tables and then update a third table depending on the comparison from two tables.
let's say I have Table A - the one I need to update
Table B and Table C. both of these tables have a common fieldname CustomerName, now when CustomerName from Table A and CustomerName from Table C are the same, I need to update Table A CustomerNameExist field with something like 'YES'
Let me know if I'm making sense here.
View Complete Post