Basic Question

[chris11590]

I ve read about inner join and outter joins. Are these joins a type of queries or two different entities?

I created an append query; however, it did not append the tables. the message about ," do you want to append ..." appear, I proceed with yes. nothing occurred. what am i doing wrong?

 

[MSAccessRookie]

I ve read about inner join and outter joins. Are these joins a type of queries or two different entities?

I created an append query; however, it did not append the tables. the message about ," do you want to append ..." appear, I proceed with yes. nothing occurred. what am i doing wrong?

TO THE BASIC QUESTION:

An INNER JOIN between two tables includes ONLY all rows that satisfy the query where there is a result from BOTH Tables

An OUTER JOIN between two tables includes ONLY all rows that satisfy the query where there is a result from BOTH Tables, and ALSO includes the remaining members of the query from one of the tables matched with NULL values for records that are not present in the other table.

TO THE SECOND QUESTION:

I believe that an append query must be based on an INNER JOIN query resultset. Is that perhaps part of your problem?

 

[chris11590]

You are alway so helpful and I want to thank you for that.

but im having diffculty understanding joines. will continue to look for a definition in dummies' version.

 

[MSAccessRookie]

You are alway so helpful and I want to thank you for that.

but im having diffculty understanding joines. will continue to look for a definition in dummies' version.

I do not know what version of MS Access you are using, but in the book called "Microsoft Access 2003 ALL-IN-ONE DESK REFERENCE For Dummies", between pages 197 and 200 there is a section called "Working with Multiple Related Tables" that explains JOINS from a functional point of view, an SQL poit of view, and a design point of view. I am sure that the other "Access for Dummies" books have a similar section that you can review. Perhaps this could be a good starting point.

NOTE: I am not too ashamed to admit that we have used this book to so often that I probably will need to buy a new copy at some point in the future.

 

[chris11590]

ive entered a postive comment along time ago. thak you again

 

[MSAccessRookie]

ive entered a postive comment along time ago. thak you again

Thanks for the comments, and I am always glad to assist another person in a way similar to have I have been assisted here in the past.