Did you use speech marks around the column names when creating the tables?
If so that makes them case sensitive and you'll always need them (unless
there all lower case)
- Stuart
> -----Original Message-----
> From: William Winter [SMTP:wilscott@earthlink.net]
> Sent: Friday, October 12, 2001 4:29 AM
> To: pgsql-general@postgresql.org
> 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