EvilZone

Programming and Scripting => Web Oriented Coding => : Code.Illusionist November 19, 2014, 09:36:15 PM

: [SQL] Where expression problem [SOLVED]
: Code.Illusionist November 19, 2014, 09:36:15 PM

Hello there, I am using Microsoft Access 2007 and this is my SQL code:

:

SELECT [First Name] , [Invoice Date]
FROM Customers AS c, Invoices AS i
WHERE (c.[First Name] LIKE 'A*') AND (i.[Invoice Date] BETWEEN #1/1/2006# AND #3/3/2006);
My table names are Customers, and as well Invoices, and table columns are First Name and Invoice Date. That's all from Northwind database.

I don't understand why my  SQL querry doesn't work.

: Re: [SQL] Where expression problem
: Code.Illusionist November 20, 2014, 08:22:05 AM

It was error simply saying: You have error at "Expression" , blah blah. I didn't create database, it's wide known Northwind database, avaliable in Access and on internet for use. They created Filed name like that, I would never do such thing, because I will have to use [] forever... For the wildcard, in SQL Access , we use * , but i am familiar with % as well.

And thanks, the true error was with # , i missed one. Such idiot. Thank you man.