hi everybody,
i need a sql query that works in mssqlServer
the query is to get a difinite number like
update dbo.1 set id = 0 where dbo.1.number = dbo.2.number
got me?
i need to set value in table 1 in column "id" = 0
where the value in column "number" in table 1 == the value in column "number" in table 2
and i want to inform the query a difinite value of dbo.2.number
i need a sql query that works in mssqlServer
the query is to get a difinite number like
update dbo.1 set id = 0 where dbo.1.number = dbo.2.number
got me?
i need to set value in table 1 in column "id" = 0
where the value in column "number" in table 1 == the value in column "number" in table 2
and i want to inform the query a difinite value of dbo.2.number