Re: Newbie

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