Multiple table join statement question

Okay, I have a database, not designed by me, but I have to work with it, with these tables: _Owners_ OwnerID OwnerName etc _Clients_ ClientID OwnerFK ClientName etc _Users_ UserID ClientFK FirstName etc _Bridge_ BridgeID UserFK FileFK _Files_ FileID FileName etc What I need to do is select

Re: Multiple table join statement question

Forget it, this was much easier than I expected. Figured it out! Thanks, Ray Ray Champagne wrote: Okay, I have a database, not designed by me, but I have to work with it, with these tables: _Owners_ OwnerID OwnerName etc _Clients_ ClientID OwnerFK ClientName etc _Users_