misc questions

Hi folks

Few questions..

1: Has anyone found a way to fake INNER JOINS, basically I'm helping someone
convert some MSSQL code over to Postgres and they use INNER JOINS heavly

2: Have any of y'all ever seeen this error

""transformExpr: does not know how to transform node 501 (internal error)"

from statement:

"SELECT DISTINCT ss.stateID, ss.stateValue FROM State ss INNER JOIN Standard
st ON ss.stateID = st.stateID"
 It stikes me as kinda strange because first and formost it should complain about
the INNER JOIN and not this other thing.        


3: what is the maximum depth of nested sub queries ?

4: just out of the blue, how great or not great is our alpha support ?

Jeff