Mirek Hankus ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description Outer join does not report rows with null values Long Description I'm running two databases (7.1.2). Same structure, the only difference is data stored in them. When I run same query with outer join it returns only rows with coresponding rows in both tables, and no rows with null values (as it should report). In the other database query works fine (returns coresponding rows and rows with no coresponding values). I'know that it is impospble to reproduce, so I report it only for your information. Sample Code No file was uploaded with this report ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly