LionSkyWalker
Programmer
Hi there.
I'm having troubles with some updates, but here is the first:
How can I update a Field, that get the value from a Count statement between 2 tables? Here's what I'm trying to do:
Update TableX Set Field1 = (
SELECT Count(*) FROM Table1 INNER JOIN Table2 ON Table1.ses_id = Table2.ses_id WHERE Table1.status In ('E','A'))
I hope someone could help me...
I'm having troubles with some updates, but here is the first:
How can I update a Field, that get the value from a Count statement between 2 tables? Here's what I'm trying to do:
Update TableX Set Field1 = (
SELECT Count(*) FROM Table1 INNER JOIN Table2 ON Table1.ses_id = Table2.ses_id WHERE Table1.status In ('E','A'))
I hope someone could help me...