help with recordset query
hi,
i am trying to create an advanced clients results page, i created it using data assist and going to keep the view buttons etc, however i need to join the tables.
i basically want to join all the tables together and they all have a key that relates to each other.
problem is when i try this just with a few tables i get no records even though there are clients and clients that have policies in protection table.
the query so far is this:
Select
*
From
buytolet Inner Join
clients On buytolet.clients_ClientID = clients.ClientID Inner Join
generalinsurance On generalinsurance.clients_ClientID = clients.ClientID
Inner Join
mortgage On mortgage.clients_ClientID = clients.ClientID Inner Join
users On clients.ClientUserID = users.UserID Inner Join
protection On protection.clients_ClientID = clients.ClientID
it returns no records, can anyone help?
many thanks