From: | Lynna Landstreet <lynna(at)spidersilk(dot)net> |
---|---|
To: | PgSQL-Novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Problems with select statement |
Date: | 2006-01-20 07:36:27 |
Message-ID: | BFF5FD2B.24576%lynna@spidersilk.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On 1/19/06 3:47 PM, Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> wrote:
> Okay, if that works, that probably implies that some of the users aren't
> matching up with relation_types or languages. Are you getting NULL outputs
> for the r and/or l columns for the people that were missing before?
Yes - it looks like some of them didn't have values in those columns (I need
to more clearly mark those fields in the form where people enter data as
required). So I guess that was what threw it somehow?
> I don't know how good they are, but...
> http://www.devx.com/dbzone/Article/17403/0/page/1
> http://www.w3schools.com/sql/sql_join.asp
Thanks! And thank you to everyone else who recommended resources as well - I
definitely have my next batch of reading lined up now...
Lynna
--
Spider Silk Design - http://www.spidersilk.net
509 St Clair W Box 73576, Toronto ON Canada M6C 1C0
Tel 416.651.2899 - Toll Free 1.866.651.2899 - Cell 416.873.9289
From | Date | Subject | |
---|---|---|---|
Next Message | First Last | 2006-01-20 08:24:37 | column number instead of column name |
Previous Message | Agnes Bocchino | 2006-01-20 06:50:32 | Initdb panic: invalid record offset at 0/0 creating template1 |