-
From: "Dmitri Colebatch" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 14, 2002 12:13 AM
Subject: [SQL] join question - three tables, two with foreign keys to the
first
> hey all,
>
> here's my situation. three tables:
>
> create ta
> why do you expect nulls?
probably because my sql is extremely rusty (o:
> SELECT ... FROM t1 LEFT JOIN t2 ON t1.col1 = t2.col2;
>
> returns nulls for the b-columns in the select list, if you have a row
> in t1 with a value t1.col1, that does not appear as col2 in any row of
> t2. In your exam
Kris,
I'm assuming you dont want to do this, but
just in case you're not aware of the option - the JDBC API exposes this
information.
hth
dim
- Original Message -
From:
Kris
To: [EMAIL PROTECTED]
Sent: Saturday, June 22, 2002 8:30
PM
Subject: [SQL] Obtaining p