Is there a way to do CONNECT BY queries in Access?

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

Guest

I'm trying to do CONNECT BY query in Access. Here is the query in Oracle
and I would like to be able to do the same in Access.

SELECT fkJobID,
fkDependentJobID,
level
FROM tblJobs
WHERE LEVEL <= :ai_level
START WITH fkdependentjobid = :al_job_id
CONNECT BY PRIOR fkjobid = fkdependentjobid and level <= :al_level
 
On Wed, 19 Oct 2005 21:24:09 -0700, "K. Spangelo" <K.
I'm trying to do CONNECT BY query in Access. Here is the query in Oracle
and I would like to be able to do the same in Access.
Click to expand...

Unfortunately, that syntax is not supported.

John W. Vinson[MVP]
 
Back
Top