|
lesponce
Starting Member
6 Posts |
 Posted - 12/06/2012 : 19:57:02
|
I need to update a field with value '1' on Table A, but I need to join to Table B to check if the customer that I'm going to update on table A, exists on Table B. If the customer does not exist on table B, then I can't update Table A.
How do I do that?
On Table A I'm going to set FLAG = '1'
WHERE FLAG on TABLE A is NULL and Does exists on TABLE B |
|
T-SQL UPDATE JOIN Two Tables
