RIAS
asked on
sql query with criteria
Hi,
Cheers
Cheers
http://www.sql-tutorial.net/ may help but as you didn't post a question it would be impossible to provide answer
ASKER
Sorry the query is :
How do I write a sql query for--
Select * From Personal_Details Where Status at Input_Date = Activeor Preserved Pensioner or Pensioner or Widow or Child
OR where Status at Input_Date = No Liability
and Dateleft,Dbdate, Pdpencomm or Topaid later than Input_Date less 1 Year
Cheers
How do I write a sql query for--
Select * From Personal_Details Where Status at Input_Date = Activeor Preserved Pensioner or Pensioner or Widow or Child
OR where Status at Input_Date = No Liability
and Dateleft,Dbdate, Pdpencomm or Topaid later than Input_Date less 1 Year
Cheers
ASKER
I tried attaching the query in code but it didnt get updated.Sorry about that.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Cheers mate!!