Binary Trees in Access SQL

[JaimePremy]

Hi Everybody

Can anyone tell me if it's possible to create binary tree queries in
Access Sql?

Thanks
Jaime

[Tom van Stiphout]

On 7 Apr 2007 01:40:56 -0700, "Ja********@gmail.com"
<Ja********@gmail.comwrote:

Not really, because Access (better: Jet) does not support recursive
queries. SQL Server 2005 does, so perhaps the free Express Edition is
something you should be looking at.

If you have to stay with Jet, you repeatedly query one level at a
time.

-Tom.

>Hi Everybody

Can anyone tell me if it's possible to create binary tree queries in
Access Sql?

Thanks
Jaime

[JaimePremy]

On Apr 7, 1:02 pm, Tom van Stiphout <[e-mail]:

On 7 Apr 2007 01:40:56 -0700, "[e-mail]"

<[e-mail]:

Not really, because Access (better: Jet) does not support recursive
queries. SQL Server 2005 does, so perhaps the free Express Edition is
something you should be looking at.

If you have to stay with Jet, you repeatedly query one level at a
time.

-Tom.

Hi Everybody

Can anyone tell me if it's possible to create binary tree queries in
Access Sql?

Thanks
Jaime- Hide quoted text -

- Show quoted text -

Thanks for the answer Tom, I think I have to definetely look into SQL
or at least MSDE.
Regards, Jaime
PS. By the way Tom are you Dutch? In dat geval blij van een
landgenoot te horen in dit verre Brazilïe.