Join works only if the files being joined share a common field.

As of this writing, YQL doesn't allow you to link tables through common keys (a join), but only permits you to use the results of one query inside another (a subquery).

THE British are unfit to join the common market because they differ “profoundly” from continental Europeans, Charles de Gaulle declared in 1963.