brain cramp or bug: inner join returns rows w/null
From: robert <gnuoytr_at_rcn.com>
Date: 24 May 2004 14:14:08 -0700
Message-ID: <da3c2186.0405241314.336dec01_at_posting.google.com>
running 8.1.7 server, 8.1.6 client.
Date: 24 May 2004 14:14:08 -0700
Message-ID: <da3c2186.0405241314.336dec01_at_posting.google.com>
running 8.1.7 server, 8.1.6 client.
i *thought* inner join should not return nulls, but not only that, but i get way more rows than i'm expecting.
assume:
order table:
order_number
order_line table:
order_number
order_line_number
value
assume 1,000 order rows, 20,000 order_line rows all have an
order_number and value.
the following:
select value from order_line, order
where order_line.order_number = order.order_number
returns rows with value = null
??
not only that, but the number of returned rows is app 65,000.
brain cramp or bug???
thanks,
robert
Received on Mon May 24 2004 - 23:14:08 CEST