philwes83170
MIS
I have two tables Account and AccountExtra. Account is the primary table and the key is AccountID. AccountExtra is Left Joined via AccountID, since not every account will have data for the extra fields.
I need to update a field in the AccountExtra table when a value is true in one of the Account table fields. I'm not a very experienced SQL user so I'm having trouble working out the syntax. Help Please...
I need something like this:
Update AccountExtra
Set AccountExtra.Field1 = 'X'
Where Account.Field5 = 'X'
I'm not sure how to work out the joins into the syntax.
I need to update a field in the AccountExtra table when a value is true in one of the Account table fields. I'm not a very experienced SQL user so I'm having trouble working out the syntax. Help Please...
I need something like this:
Update AccountExtra
Set AccountExtra.Field1 = 'X'
Where Account.Field5 = 'X'
I'm not sure how to work out the joins into the syntax.