JOIN-BY
Wednesday, February 23, 2011
2:16 PM
JOIN-BY: create a new relation via common keys
<alias> = JOIN <alias2> BY <fieldname2>, <alias3> BY <fieldname3>; 
Creates an inner join; data that doesn't match is omitted. 