MySQL View Syntax (Date)
- Posted:
- Proposals: 6
- Remote
- #102899
- Archived
Sheffield 
Description
Experience Level: Intermediate
Need help with syntax for simple View in MySql. Can't get Date to work.
One table involved (tblFileDetail)
Select * from tbleFileDetail WHERE (Status = 'Active' OR Status = 'Hold') OR (Status = 'Sold' and DateOfSale >= Now() - 60)
One table involved (tblFileDetail)
Select * from tbleFileDetail WHERE (Status = 'Active' OR Status = 'Hold') OR (Status = 'Sold' and DateOfSale >= Now() - 60)
New Proposal
Create an account now and send a proposal now to get this project.
Sign upClarification Board Ask a Question
-
There are no clarification messages.