Software Bugs and Solutions
Home
Tuesday, 28 August 2012
update two tables in one statement in SQL
UPDATE
Table1
SET
Table1
.
LastName
=
'XXXXXX'
FROM
Table1 T1
,
Table2 T2
WHERE
T1
.
id
=
T2
.
id
and
T1
.
id
=
'01'
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment