SQL query

[rac55]

Hi

I am trying to pull information from a database using a sql statement. I need pull where region=all...but I do not know the syntax for this. The sql is;

SELECT * FROM tblEmployee INNER JOIN
tblSignatures ON tblEmployee.MngDir = tblSignatures.MngDir
WHERE (tblEmployee.YearOfAward = '2003') AND (tblEmployee.Region = '???') OR
(tblEmployee.EmployeeNo = '') OR
(tblEmployee.Surname = '') AND (tblEmployee.FirstName = '')
ORDER BY tblEmployee.YrsOfService

Any help would be greatly appreciated
Thanks

 

[Katy44]

Is there a specific value for the region field that indicates "all"? If not, then just leave it out, and the query will not be limited by region:

SELECT * FROM tblEmployee INNER JOIN
tblSignatures ON tblEmployee.MngDir = tblSignatures.MngDir
WHERE (tblEmployee.YearOfAward = '2003') OR
(tblEmployee.EmployeeNo = '') OR
(tblEmployee.Surname = '') AND (tblEmployee.FirstName = '')
ORDER BY tblEmployee.YrsOfService