tag:blogger.com,1999:blog-9444317.post112687830072451674..comments2024-03-10T08:48:34.026+00:00Comments on Nemeton: scary thingsYewtreehttp://www.blogger.com/profile/02028699564003381058noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-9444317.post-1126881694932930672005-09-16T14:41:00.000+00:002005-09-16T14:41:00.000+00:00It's Easy:An inner join is a query that returns al...It's Easy:<BR/><BR/>An inner join is a query that returns all related records from two tables and none of those that are not related.<BR/><BR/>Master Table: All related records.<BR/>Detail Table: All related records.<BR/><BR/>An outer join is a query the returns all records from your master table (the first one named in the join) regardless of whether they have related records in the detail table (the second one stated in the join), but only returns those records from the detail table that have related records in the master table.<BR/><BR/>Master Table: All records.<BR/>Detail Table: Only related records.<BR/><BR/>See? Easy!<BR/><BR/>kevinpaultracy.blogspot.comKPThttps://www.blogger.com/profile/15312686959363640016noreply@blogger.com