> as per the manual, when joining 2 tables, if one entry is not found in the
> second table , a null records is displayed, but in that small example,
> it's not working like this:
>
> CREATE TABLE test1 (
> number tinyint(3) unsigned NOT NULL DEFAULT '0' ,
> PRIMARY KEY (number));
>
> INSERT INTO test1 VALUES("1");
> INSERT INTO test1 VALUES("2");
> INSERT INTO test1 VALUES("3");
>
> CREATE TABLE test2 (
> number tinyint(3) unsigned NOT NULL DEFAULT '0' ,
> cnumber char(10) NOT NULL DEFAULT '' , PRIMARY KEY (number)
> );
>
> INSERT INTO test2 VALUES("1","one");
> INSERT INTO test2 VALUES("2","two");
>
> if you do :
>
> select test1.number,test2.cnumber from test1,test2 where
> test1.number=test2.number
>
>
> the result is
>
> number cnumber
> 1 one
> 2 two
>
>
> instead of
>
> number cnumber
> 1 one
> 2 two
> 3
>
> Regards
>
> Philippe Parmentier
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php