join and relates

[ميلاد احمد]

You can use it for join 2 tables (or more): to have one as result
Or to relate 2 tables (or more) without joining.
TO use it, the same column must exist in the 2 tables (The same information like identification ID or the name of regions etc.).
It is useful if you have a lot of information in the tables and you need to get the information from two tables without joining.