help with recordset query

4/01/2010 11:58 ammr hankey

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

Email me with all replies to this thread

Title:

Public Message: (viewable by anyone reading this thread)
(do not cut and paste code into this field unless necessary, attach copies of your pages so they can be opened in Dreamweaver for debugging)

Type in the characters exactly as displayed below - if you don't complete the Captcha correctly you will get a blank page, so you may want to copy the text of your message before you submit!

Quote message in reply?

Private Message: (viewable only by you, the person you are replying to, and WebAssist employees)
(only put truly private information in this area such as ftp details and phone numbers. Keep as much of your post public as possible)

These attachments are private (viewable only by you, the person you are replying to, and WebAssist employees)

Manage Attachments

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

help with recordset query

4/01/2010 11:58 ammr hankey