var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Need help with a simple UPDATE
I have 2 tables:
uniqueID int uniqueID int
aFlag smallint field1 int
I need to UPDATE tableA such that the value of aFlag is 1
if a record EXISTS in tableB with the same uniqueID.
Thanks in advance for any input,
You'd do better not having a flag though. The best way to test to see if there is data in tableB for that id is to simply look in tableB.
set aFlag = 1
where exists( select 1 from tableB b where b.uniqueID = tableA.uniqueID )
Yes, thank so much.
I agree - it wasn't my design.
The resulting lack of referential integrity is causing problems elsewhere -
thus the need for this UPDATE