>
>Brett,
>Would you try this :
>
>SELECT P.Username, P.Phone, C.KidFirstName, C.KidLastName,
>S.Status, Pr.Priority
>FROM force Parent P ;
>left join StatusLookup S on P.StatusKey = S.StatusKey ;
>left join Child C on P.ItemKey = C.ItemKey ;
>left join PriorityLookup Pr on C.PriorityKey = Pr.PriorityKey ;
>WHERE P.Username = "SMITHBOB"
>
>Cetin
What does the FORCE do? And why did you convert Parent to P, Child to C etc?
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope