J

JET Database Engine, 20

JOIN (reserved word), 461, 463

join table, 39

joins

cross joins, 243

expression, joining on an, 244–245

FROM clause, joining tables in, 234–235

full joins, 241–243

full outer joins, 241–243

INNER JOIN statement, 235–236

legacy outer joins, 239

multicolumn joins, 239–240

multi-table joins, 245–246

non-equijoins, 240–241

outer joins, 236–239

overview, 233

predicate, filtering records in join clause using, 243–244

SELECT statement and, 244–245

special-purpose join operations, 241–246

WHERE clause, joining tables in, 233–234