|
| Docs |
| What is it? |
| What it isn't? |
| Example |
| How to run |
| Installation |
| Credits |
| BSD License |
| Gallery |
| Subselects |
| Fan and Chasm Traps |
| Sakila |
| Big Examples |
| Links |
| Home Page |
| Code |
| Online Demo |
| Feedback |
| Email (reCAPTCHA) |
| Powered by |
 Python
|
|
|
| Pyparsing |
|
|
| Logo |
| Daniel Saarimäki |
| Updated 27 Jul 2009 |
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)
