I'm Having a hard time with this statement: Select Jobs.*, ProjectedDates.* FROM Jobs, ProjectedDates WHERE (Plotted = False) And (JobName = 'Boulder Valley') AND (BuilderName = 'Elliott Homes') AND (Jobs.JobID = ProjectedDates.JobID)
Can anyone see why? the record and field names certainly do exist...any help appreciated! ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org