I have a strored procedure which part of it is as below..
It keeps syaing incorrect syntax...
ANyone tell me what is wrong?
insert into Details (FIeld naems etcc)
SELECT FIeld Names etc
FROM Another_Details left outer join users on aother_details.officer_id = users.attendant_id
Where ID = @KeyID and Registration_No >''
WHERE (Users.Account_Disabled = '0')
Obviously field names is jst a summary of the fileds in the table..
its the WHERE (Users.Account_Disabled = '0') bit which has caused the problem...