OK, I know I should understand the whole left,right, inner, outer crud, but my brain is full of other things more important, at least until I need it. Here is my question I have a parent table x and a child table y. y is linked to x on key1. What I need is one SQL select that will find all the children that meet a certain criteria and report the values, but for those x's where there are no children y I need to show the data from parent x and blanks for the field from child y. Can anyone help me on this as my head is hurting from hitting the brick wall.
Table x
field x.Key1
field x.Document_Number
Table y
field y.Key1
field y.Delivery_Date
field y.Delivery_Name
I need to see all the deliveries for a certain document number, but I need to also see when a document number has not been delivered yet. In one SQL select
TIA
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope