T-SQL Update Inner Join Syntax
Posted on 2006-06-02
Quick syntax question
I have a TSQL statement that needs to update a field on both tables.
The statement is :
INNER JOIN PROSPECTIVE_CUSTOMER ON CUSTOMER.CUST_ID = PROSPECTIVE_CUSTOMER.CUST_ID
PROSPECTIVE_CUSTOMER.PLACE_STATUS = 'A',
CUSTOMER.START_DATE = '2006-9-2 00:00:00.000'
This will work in ACCESS, but I want to run it in query analyser, I know the syntax is similar to
SET FIELD = VALUE
INNER JOIN TABLE ON TABLE1 TABLE.ID = TABLE1.ID
But I can't find any referenec to what I am trying to achieve with the first script