what wrong in this query

Accepted answer

This is the qeury which gives you error?
select Modules,Task from ClientDetails where ProjectTitle ='selvi' where Statuss != 'Completed

Dont you see you are using two where clauses? i asked you to replace second "where" with "And"

selvi subramanian14y ago

ya thanks santhosh

selvi subramanian14y ago

Ya i try this but not works

Kunal Vaishya14y ago

try This Dear

select Modules,Task from ClientDetails where ProjectTitle ='selvi' where TRIM(Statuss) != 'Completed'

selvi subramanian14y ago

ALTER Table ClientDetails ADD Statuss VARCHAR(20) DEFAULT 'Completed' this my sql statement

Santhosh Kumar Jayaraman14y ago

You have used two times

" where ProjectTitle ='selvi' where Statuss != "

selvi subramanian14y ago

s i use only one keyword

Santhosh Kumar Jayaraman14y ago

You can have only one Where keyword..

try this

select Modules,Task from ClientDetails where ProjectTitle ='selvi' and Statuss != 'Completed'