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@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 - 16:14:08 CDT