Re: [Hsqldb-user] About hsqldb/doc/guide/ch02.html#N104E0 (JOIN...)

[fredt <fr...@us...>]

Null columns will never be joined. With LEFT OUTER JOIN, for each row of the
table on the left (outer table)  non-null will be joined with non-null
columns from the table on the right, but if there is no eligible row in the
table on the right , a new row consisting of all-null values will be used
for the table on the right.

Fred
----- Original Message ----- 
From: <loi...@bn...>
To: <hsq...@li...>
Sent: 27 May 2004 18:19
Subject: [Hsqldb-user] About hsqldb/doc/guide/ch02.html#N104E0 (JOIN...)


Hi,
Could you please give me some informations about the following paragraph:

"[...]
New Features and Changes

In 1.7.2 many enhancements have been made for better SQL support.
[...]
Most significant among these are handling of NULL values in joins (null
columns
are no longer joined) and OUTER joins (the results are now correct).
[...]"

So If I make a JOIN, null columns will not be joined but with [LEFT | RIGHT]
OUTER JOIN,
they will, am I right?

TIA,
Loïc




This message and any attachments (the "message") is
intended solely for the addressees and is confidential.
If you receive this message in error, please delete it and
immediately notify the sender. Any use not in accord with
its purpose, any dissemination or disclosure, either whole
or partial, is prohibited except formal approval. The internet
can not guarantee the integrity of this message.
BNP PARIBAS (and its subsidiaries) shall (will) not
therefore be liable for the message if modified.

                ---------------------------------------------

Ce message et toutes les pieces jointes (ci-apres le
"message") sont etablis a l'intention exclusive de ses
destinataires et sont confidentiels. Si vous recevez ce
message par erreur, merci de le detruire et d'en avertir
immediatement l'expediteur. Toute utilisation de ce
message non conforme a sa destination, toute diffusion
ou toute publication, totale ou partielle, est interdite, sauf
autorisation expresse. L'internet ne permettant pas
d'assurer l'integrite de ce message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce
message, dans l'hypothese ou il aurait ete modifie.



-------------------------------------------------------
This SF.Net email is sponsored by: Oracle 10g
Get certified on the hottest thing ever to hit the market... Oracle 10g.
Take an Oracle 10g class now, and we'll give you the exam FREE.
http://ads.osdn.com/?ad_id149&alloc_id66&op=ick
_______________________________________________
Hsqldb-user mailing list
Hsq...@li...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user