I've got the two csv tables below.
Users:
| id | name |
|---|---|
| 1 | Bradley |
| 2 | Peter |
| 3 | Sanjay |
Purchases:
| id | date | user_id |
|---|---|---|
| 1 | 2022-11-01 | 2 |
| 2 | 2023-10-03 | 3 |
| 3 | 2023-04-21 | NULL |
I have them saved as csv files on VS Code. I want to write the below code for the two tables above.
select * from users where id not in (select user_id from purchases)
The SQL code sits in a .sql file on VS Code. When I run that code in a new file I get the below error message.
Code language not supported or defined.
How do I read in the csv files, which sit on my GDrive ("G:\My Drive\Visual Studio Code\<file_name>.csv"), into the SQL code and how can I get the code language supported?
I have SQLite extension (alexcvzz.vscode-sqlite) installed on VS Code and it is enabled globally.
I don't understand what the problem is.
