Cross Joins
The SQL Select statement now support cross joins, for example:
Select expression_list
From table_name [ , ... ] [Cross Join]
[ Where expression_group ]
[ Into results_table [ Noselect ] [ Hide ] ]
[ Group By column_list ]
[ Order By column_list ]Note: If the SQL version is set to 1900, you can
perform cross-joins with or without using the Cross Join keyword in the
SQL Select statement. To allow cross-joins with SQL version 1700, use the
Cross Join keyword explicitly in the SQL Select statement.
Joins between more than two Dynamic Query tables
You can now create joins between more than two dynamic query tables. Earlier, this
was restricted to only joins between two dynamic query tables. For
example,
Select * from ehitis where ehitis.systeem_kood = "1106800020020" AND ehitis.kood = "001" into query1
SELECT systeemi_eesvoolu_osa.id, systeemi_eesvoolu_osa.rajatis_id
FROM systeemi_eesvoolu_osa, rajatis, query1
WHERE systeemi_eesvoolu_osa.rajatis_id = rajatis.id
AND rajatis.ehitis_systeem_kood = query1.systeem_kood