join

To link two or more tables in a relational database on the basis of a common item or field.You create joins using your Database Management System (DBMS)