<div>
update &nbsp;A, B<br />
set a.Updated_by='Y' <br />
where a.FirstName=B.FirstName and a.LastName=b.LastName and a.HouseNumber=b.HouseNumbe<wbr />r
</div>


update  A, B
set a.Updated_by='Y'
where a.FirstName=B.FirstName and a.LastName=b.LastName and a.HouseNumber=b.HouseNumber

<div>
aneeshattingal thanks it worked dqmq, thanks for the advice. Its a one time mailing list that doesnt need to be real accurate. Even if it misses a good percentage its ok because its good advertisement for their services.
</div>


aneeshattingal thanks it worked dqmq, thanks for the advice. Its a one time mailing list that doesnt need to be real accurate. Even if it misses a good percentage its ok because its good advertisement for their services.

<div>
<div class="content wysiwyg-content">
Hi I have two tables<br />
<br />
Each table has<br />
<br />
Lastname,firstname,housenu<wbr />mber<br />
<br />
the first table has a column called &quot;Permit&quot; lets call this table A<br />
<br />
I need a sql statement that updates updates table A, &nbsp;and sets the permit column to 'Y' where the first, last and housumber &nbsp;match in each of table.<br />
<br />
Thanks<br />
Chuck
</div>
</div>


Hi I have two tables

Each table has

Lastname,firstname,housenumber

the first table has a column called "Permit" lets call this table A

I need a sql statement that updates updates table A,  and sets the permit column to 'Y' where the first, last and housumber  match in each of table.

Thanks
Chuck

Need update statement

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.