Inner Jion querry with where clause

[kronar]

I have a time record table and an employee table joined by EMP_No field. I set up an inner join querry to fill a list box. Works fine till I want to restrict it by date value - it just ingores the where clause. I do not get any errors when run just all the records.

Select ET.fields, JBT.fields from EMP_Table as ET inner join JBT_Table as JBT on ET.Emp_No = ET.Emp_No order by ET_Date DESC

I tried putting the where clause after the on clause.
Thanks for any help

 

[SoCalAccessPro]

Are you typing the SQL by hand, or using the GUI ?

I found a quick and dirty way to create SQL statements is to create a query, switch to SQL view and grab the SQL. Then I cut and paste to wherever it needs to go.




Tyrone Lumley
SoCalAccessPro

http://www.socalaccesspro.com

 

[Golom]

Probably need to see the WHERE clause you are inserting.

... and do you really have fields in those tables named "Fields"?

 

[PHV]

on ET.Emp_No = [!]JBT[/!].Emp_No

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[kronar]

fields is just a collection of fields from each table as in "ET.Job_Number"

where clause is " where JBT.Date < 12/30/2006"

Thanks, I will try to set this up in querry also.

 

[PHV]

Did you correct your join clause as I suggested ?