I need to create one table with fields from the sales table with similar fields from the expenses table.  There is no lookup between them. Both tables are updated via feeds from zoho creator separately.  I would like to use the blended table to produce income and expense reports and graphs.  JOIN in the query table doesn't seem to work for this.  I do not know sql so maybe I'm doing it wrong? 

 

Could both tables be edited to include a linked field that could be used to then create a query table?  Both tables have a date field, can this field be linked between the two even though each table gets updated by zc?  How would I do this?