Дата в SQL запросах в MS Access |
Previous Top Next |
Для дат используйте #:
Code: |
SELECT Students.Name,Students.BirthDate,Teachers.Name FROM Teachers INNER JOIN Students ON Students.TeacherID=Teachers.ID WHERE Students.BirthDate BETWEEN #09/02/87# AND #01/01/00# |
©Drkb::02750
Автор: Vit (www.delphist.com, www.drkb.ru, www.unihighlighter.com, www.nevzorov.org)