I have a query (attached clip of) which pulls info from 3 tables. I would like all information from the persons table and the address table to show whether there is a match or not.
I have a query (attached clip of) which pulls info from 3 tables. I would like all information from the persons table and the address table to show whether there is a match or not.
Double click on the line that connects your tables in your query and you will see options to show all records from one table and not only the one that matches
I followed this direction and receive the following error message.
"The SQL statement could not be executed because it contains ambiguous outer joins. To force one of the joins to be performed first, create a separate query that performs the first join and then include that query in your SQL statement."
I don't know how to write SQL. Can I do this in Access 2007?
Yes.I don't know how to write SQL. Can I do this in Access 2007?
Does it return that statement just after you edit the relationship, or also before it? If it does not before, where you can get the query to work (meaning it returns data, just not all the data you want), then change your query to SQL view and copy and paste the code here (so we can see your relationshipd) and we will help you edit it.I followed this direction and receive the following error message.
"The SQL statement could not be executed because it contains ambiguous outer joins. To force one of the joins to be performed first, create a separate query that performs the first join and then include that query in your SQL statement."
I only get the message after I edit the relationship.
SQL is:
SELECT tbl_Person.Person_LastName, tbl_Person.Person_FirstName, tbl_Person.Person_MiddleName, tbl_Address.Address_Streetnumber, tbl_Address.Address_Streetname, tbl_Address.Address_Mailing, tbl_Address.City, tbl_Address.Province, tbl_Address.Postal_Code, tbl_Address.Address_Type, tbl_Address.Address_Date
FROM tbl_Person INNER JOIN (tbl_Address INNER JOIN tlink_PersonAddress ON tbl_Address.[AddressID] = tlink_PersonAddress.[AddressID]) ON tbl_Person.[PersonID] = tlink_PersonAddress.[PersonID];
So, am I to assume that since you are using a linking table (tlink_PersonAddress), that you do not have a direct link between the Person and Address tables?
Does your zip file in your original post have a copy of the database for us to look at (I cannot download attachments from my current location to check, but can from my home comouter when I return there)? I think seeing your table structure and sample data is key in helping you figure this out, so if that zip file does not contain that information, can you please provide it?