ADO wont allow a LEFT JOIN with forward only cursor

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Back
Top