ADO wont allow a LEFT JOIN with forward only cursor

[David]

ADO wont allow a LEFT JOIN with a forward only curso
Why and what should I be using?

 

[Michel Walsh]

HI,


ADO have nothing to do with JOIN, the JOIN is first made, then, the
result "encapsulated" into a recordset. The following should work:


Dim rst As ADODB.Recordset
Set rst=xnn.Execute("SELECT COUNT(*) FROM a LEFT OIN b ON a.f1=b.g1")
Debug.Print rst.Fields(0).Value


assuming xnn is an already open ADO connection.




Hoping it may help,
Vanderghast, Access MVP