|
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}"