ADO wont allow a LEFT JOIN with forward only cursor

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

ADO wont allow a LEFT JOIN with a forward only curso
Why and what should I be using?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Oversensitive touchpad on modern laptops 0
Transaction problem between DAO and ADO 4
Join expression not supported - works in MA scces but not via ADO 1
join expression not supported..run in Access 2003 but not in ADO ? 1
left join via ado 3
Recordcount in ADO 10
>> ADO Updateable recordset 3
Please help with ADO Code 1

Back
Top