Skip to content
Advertisement

Use mid and inner join SQL query in VBA excel

Please find the below table where i want to execute mid and inner join SQL query.

table 1:-

enter image description here

table 2:-

enter image description here

Please find my below syntax and the respective error’s which i am facing on the same.

1st sql query syntax

error on above code.

enter image description here

2nd sql query syntax

error on above code.

enter image description here

Please guide me on the same.

Please find the expected output.

enter image description here

Advertisement

Answer

Use the below query

Sample Code

User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement