Hi All,
Is it possible to have query joints in vb6, to retrieve the data
from access database?


Thanks
Zaffar

Not “joints,” “joins.”

Joins are not a programming language feature, but a DB’s query language feature.

I believe that only Access uses “JOIN.” In Oracle you use a plus sign inside parens in the WHERE clause to establish that which Access uses JOIN for in the FROM clause.

When you issue SQL against Access from any technology (including VB6) Access will recognize the JOIN statements.