Hi,
In VB6+Access, I got error by the sql string:
sql = "Select * From Table1 Where [User] In (Select Table1.[User] From Table1 " & _
"Left Join (Select Table2.[User] From IN '' [MS Access;PWD=123456;DATABASE=" & aFileName & "] " & _
"Group By Table2.[User]) As t On Table1.[User]=t.[User]) "
Can you correct for me?
I will be very appreciated if you explain how to do such complex sql string.
In VB6+Access, I got error by the sql string:
sql = "Select * From Table1 Where [User] In (Select Table1.[User] From Table1 " & _
"Left Join (Select Table2.[User] From IN '' [MS Access;PWD=123456;DATABASE=" & aFileName & "] " & _
"Group By Table2.[User]) As t On Table1.[User]=t.[User]) "
Can you correct for me?
I will be very appreciated if you explain how to do such complex sql string.