**Describe the bug** If I have two csv files and trying to join both, it's not working. **To Reproduce** 1. Let's say we have a cust.csv file with cust_id, cust_name 2. Another CSV file named geo.csv file with cust_id, city, zipcode Run a sql like below ```%csv select cust_name, city from cust.csv as a join geo.csv as b on a.cust_id = b.cust_id``` **Expected behavior** The sql should join both the table and give cust_id and city info in a table. **Screenshots** <!--- If applicable, add screenshots to help explain your problem. --> **Potential fix** <!--- If you are aware of a potential fix, please share the details.
Describe the bug
If I have two csv files and trying to join both, it's not working.
To Reproduce
Run a sql like below
%csv select cust_name, city from cust.csv as a join geo.csv as b on a.cust_id = b.cust_idExpected behavior
The sql should join both the table and give cust_id and city info in a table.
Screenshots
Potential fix