Re: Newbie

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" <wilscott(at)earthlink(dot)net>
> Organization: EarthLink Inc. -- http://www.EarthLink.net
> Reply-To: "William Winter" <wilscott(at)earthlink(dot)net>
> Date: Fri, 12 Oct 2001 03:29:04 GMT
> To: pgsql-general(at)postgresql(dot)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
>