As of now, you need to have a relation between two tables you are trying to join in ZCQL and the absence of this has caused you the issue. The condition that has to be used in a join query must be the ROWID of the first table to the foreign key of the second table.