Skip to content

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

Open
@sn0wfree

Description

@sn0wfree

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

Metadata

Metadata

Assignees

Labels

enhancementNew feature or request

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions