Help joining tables and restricting records
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..