LinkedIn2. If you're planning on getting a mortgage to purchase a home or for a refinance, please do not obtain ANY credit, increase your credit debts (use your credit accounts) or please don't even THINK of applying for new credit until your new mortgage loan has funded and closed.
Join (merge) Tables (lists) - by columns match in Excel. Join is to combine two tables by matching the values in corresponding columns. In result, you will get a merged table which consists of the first table, plus the matched rows copied from the second table.
There are three basic types of join: 1  INNER join compares two tables and only returns results where a match exists. 2  CROSS join compares two tables and return every possible combination of rows from both tables. 3  OUTER join compares two tables and returns data when a match is available or NULL values otherwise.