| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | William Winter <wilscott(at)earthlink(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Newbie |
| Date: | 2001-10-15 16:03:46 |
| Message-ID: | Pine.BSF.4.21.0110150902210.11740-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vivek Khera | 2001-10-15 16:08:40 | Re: loggin |
| Previous Message | Mihai Gheorghiu | 2001-10-15 15:53:47 | Re: Problem in installing Postgresql-7.1.2 |