On Fri, 12 Oct 2001, William Winter wrote:
> 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! First off, what's the error you're getting? If you're getting a table/field name not found, try double quoting names. If you double quoted (or used an interface that does so for you) the names in mixed case on the create, you'll need to double quote the names in queries from that point forward. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
