| From: | "Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)uk> |
|---|---|
| To: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Newbie |
| Date: | 2001-10-15 13:52:08 |
| Message-ID: | E2870D8CE1CCD311BAF50008C71EDE8E01F746F0@MAIL_EXCHANGE |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)earthlink(dot)net]
> Sent: Friday, October 12, 2001 4:29 AM
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tony Grant | 2001-10-15 13:58:13 | inserting data into multiple tables |
| Previous Message | Brent R. Matzelle | 2001-10-15 13:35:32 | Re: Problem in installing Postgresql-7.1.2 |