Is there a JOIN limit

Is there a join limit to the number of joins that can occur within one
query? Some one asked me that question and I didn't know how to answer. I
do know that there are performance issues with "too" many joins but I do not
believe that there is an imposed limit based in the DBMS software.
Thank You for your comments?Maximum number of tables referenced in a query is 256.
http://www.aspfaq.com/2345
http://www.aspfaq.com/
(Reverse address to reply.)
"J" <j@.h.com> wrote in message news:HdpTd.2762$Hs.59@.okepread04...
> Is there a join limit to the number of joins that can occur within one
> query? Some one asked me that question and I didn't know how to answer.
I
> do know that there are performance issues with "too" many joins but I do
not
> believe that there is an imposed limit based in the DBMS software.
> Thank You for your comments?
>sql