|How I get Join association? [message #18021]
||Wed, 28 June 2006 19:13
Originally posted by: clodoaldo.phoebus.com.br|
I'm using SQLParser and I have the problem. When the query exists more than one join clause occurred some problem. For example:
SELECT t1.c1 , t2.c2, t3.c3 FROM TABLE1 t1 LEFT JOIN TABLE2 t2 ON t1.c1 = t2.c2 RIGHT JOIN TABLE3 t3 ON t3.c3 = t2.c2
For first join i get the TableRefLeft (= TABLE1) and TableRefRight(= TABLE2) but I do not obtain TableRefLeft for second join (return null).
Exists another form for this intention?
Powered by FUDForum
. Page generated in 0.01831 seconds