Get Reverse Snowflake Joins at SourceForge.net. Fast, secure and Free Open Source software downloads   
  

Subselects-partially supported

Correlated subselects look like:

select m.id ,
 (select s.value from sub_table s where s.id = m.id)
from main_table m

Currently the field m.id on the master side has to be explicitly mentioned in the master select, otherwise there is an warning on the console "Warning: node M, port id unrecognized"

"IN" clauses are also supported, but the line to the subselect does not point to any field.

select * from a where
 a.a in (select * from t_a) and
 a.b in (select * from t_b) and
 a.c in (select * from t_c)
In such case it is possible to add the needed field in t_a and manually edit the dot file and replace A:a:e -> workaround_1 ; with ex A:a:e -> T_A:field ;. The command line for rendering is dot -T png -Edir=none -Grankdir=LR -o current.png current.dot

select * from a where
 a.a in (select a.value from t_a) and
 a.b in (select * from t_b) and
 a.c in (select * from t_c)