Without providing the error message returned, we can only guess. One likely issue is "Plotted = False", because all values must be quoted except numbers. Better to use Plotted = 'f'.
Keary Suska Esoteritech, Inc. "Leveraging Open Source for a better Internet" > From: "William Winter" <[EMAIL PROTECTED]> > Organization: EarthLink Inc. -- http://www.EarthLink.net > Reply-To: "William Winter" <[EMAIL PROTECTED]> > Date: Fri, 12 Oct 2001 03:29:04 GMT > To: [EMAIL PROTECTED] > Subject: [GENERAL] Newbie > > 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 > ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
