MS Access Join Two Tables Software 7.0 Horizontally merge (combine, match, union) two Access tables into one by a common column (field) of data. The two tables can be located in the same Access file or two different Access files. No complicated options or SQL knowledge required. For Access experts, this is similar to an OUTER JOIN but a new table is created with the results. See also: combine, match, union, merge, combining, joining, matching, merging, 2, fields, data, sql, one, 1, many, files, mdb, ms access, microsoft, unioning, update, updating, existing, new, another, multiple, 2000, 2007, 2003, single, sql statement, query, queries, outer join, inner join, outerjoin, innerjoin, querying, db, database, ms-access, rows, columns, all records, both, unmatched, matched, relational, relation, common, value, return, returned, cartesian, full, get, getting, linking, by, separate, seperate, distinct, accessing, different, same, similar, mdb, left, right, more than, sides, relationship, stored, external, internal, together, aggregate, upsize, upsizing, flat, identical, diff, xp, compare, design, grid, twice, once, large, small, primary key, secondary, odbc, link, linking, recordset, records, append, names, scan, index, type, size, mismatch, tsql, select, from, by, all, both, nested, comparing, special, count, zero, pid, id, syntax, remove, duplicate, dupe, null, where, three, four, five, six, seven, eight, nine, ten, 3, 4, 5, 6, 7, 8, 9, 10, cross, datatype, combination, complicated, criteria, generate, create, condition, contains, into, normalize, normal form, 3rd, 1st, 2nd, first, second, third, updating, crosstab, summing, integer, long, single, double, currency, date, bit, boolean, byte, guid, char, decimal, characters, text, memo, binary, long, natural, sql, help, split, splitting, group, two-way, unioning, updateable, combinding, add, adhere, affix, append, assemble, attach, blend, clamp, coalesce, cement, compound, conjoin, connect, fasten, fuse, hitch, knit, lock, lump, together, melt, mix, pair, put, slap, splice, stick, tack, tie |