|Subject:||SQL subquery help|
I am trying to run a query that allows me to update values only for a particular user and only with a time frame. The query runs but it updates the values for all users. What am I doing wrong?
Thanks very much for any help. Here's the query in 2 parts:
select [patid], [id] ,[date],[mssql_user],[type]
where mssql_user = 'ghaft'