join@"join"
The "join" command creates a new table which contains all
columns from two source tables. The resultant
table contains rows from each source table
where specified columns match according to the specified comparison.
<"join" <table-1> "using" <column-1>
"with" <table-2> "using" <column-2> "+"
"forming" <table-3>
"where" <comparison>
creates <table-3> from the join of <table-1> and <table-2>.
Each combination of rows where
«column-1> in <table-1> <comparison> <column-2> in <table-2>
is true, creates a row in <table-3>.