On 2007/10/12, at 23:22, Pavel Stehule wrote:
you get 0 rows. moo@xxxxxxx isn't anywhere and bar@xxxxxxx cannot do
pair with any. else 0 * 1 = 0
Thanks, go it now. Basically very simple.
I probably need to approach the problem different. So both are read
"independent" or something like this.
--
[ Clemens Schwaighofer -----=====:::::~ ]
[ TEQUILA\ Japan IT Engineer ]
[ 6-17-2 Ginza Chuo-ku, Tokyo 104-0061, JAPAN ]
[ Tel: +81-(0)3-3545-7703 Fax: +81-(0)3-3545-7343 ]
[ http://www.tequila.co.jp http://www.tbwajapan.co.jp ]
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend