sn0wfree/ClickSQL

add new usage: use cik_dt only to merge rather than (cik_dt,cik_iid)

Opened this issue · 0 comments

sql = f"select * from ({sql1}) all full join ({sql2}) using (cik_dt,cik_iid) {settings}"

add new usage: use cik_dt only to merge rather than (cik_dt,cik_iid)
when join two sql, but join column is only cik_dt or cik_iid.
such as:

sql = f"select * from ({sql1}) all full join ({sql2}) using (cik_dt)  {settings}" 

or

sql = f"select * from ({sql1}) all full join ({sql2}) using (cik_iid)  {settings}"