Further to this thread: https://www.mrexcel.com/board/threads/sql-query-in-excel.1160445/#post-5631185 my data now is entirely on Sheet1. A1 contains Fruit, B1 contains Store, C1 contains Fruit and D1 contains Store. This query doesn't work: strSQL = "SELECT [Sheet1$A1], [Sheet1$B1], [Sheet1$D1] " & _ "FROM [Sheet1$A1:B6] INNER JOIN [Sheet1$C1:D4] ON [Sheet1$A1] = [Sheet1$C1]" with an error message: Join expression not supported Can someone tell me what is wrong? Thanks

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

SQL joins in VBA

Thread starter tiredofit
Start date Feb 3, 2021

tiredofit

Well-known Member

Feb 3, 2021

Further to this thread:

Code:

https://www.mrexcel.com/board/threads/sql-query-in-excel.1160445/#post-5631185

my data now is entirely on Sheet1.

A1 contains Fruit, B1 contains Store, C1 contains Fruit and D1 contains Store.

This query doesn't work:

Code:

strSQL = "SELECT [Sheet1$A1], [Sheet1$B1], [Sheet1$D1] " & _
             "FROM [Sheet1$A1:B6] INNER JOIN [Sheet1$C1:D4] ON [Sheet1$A1] = [Sheet1$C1]"

with an error message:

Code: