Join works only if the files being joined share a common field.
join只有在所要连接的文件共享某个共同的域时才会工作。
2
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).