I need to write an SQL query that joins two tables in my database and uses an INNER join to restrict record selection to a field like zipcode or social security number..

When I parse the following query:

select * from EMPLOYEE join JOB_TITLE on EMPLOYEE.JobID = JOB_TITLE.JobID Where zipcode Inner '08801' and '08899'

I receive the following error:
Msg 4145, Level 15, State 1, Line 76
An expression of non-boolean type specified in a context where a condition is expected, near 'inner'

Numerous alterations and I can't seem to get it.. Any help is greatly appreciated..

Do you mean this:

   WHERE zipcode IN('08801','08899')

-Peter

select * from EMPLOYEE inner join JOB_TITLE on EMPLOYEE.JobID = JOB_TITLE.JobID Where zipcode In( '08801' and '08899')



urt

That did the trick.. Thanks alot guys..:)