<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0"><channel><category>pcsoft.us.windev</category><copyright>Copyright 2026, PC SOFT</copyright><lastBuildDate>24 Nov 2017 05:00:00 Z</lastBuildDate><pubDate>24 Nov 2017 05:00:00 Z</pubDate><description>I see from the documentation (here) that the query editor cannot handle sub-queries. Testing this I find that:&#13;
- a query including 2 sub-queries can be created and pasted into the query editor&#13;
- (I found posts elsewhere by Peter Holman showing that sub-queries can be created)&#13;
- but the query cannot then be re-engineered.&#13;
&#13;
Using the report editor I find that unless a query can be re-engineered, a new sort level cannot be added using the report description, (although it can be added directly to the SQL code).&#13;
&#13;
Does anyone see any disadvantages in this? Or are there workarounds? Should I wait for Wx28 maybe? :-)&#13;
&#13;
Should I create a query in the query editor which contains all the clauses except the sub-query/queries, then re-engineer it and save the query, then use the report editor to set up all the report settings, then go back to the query editor and add in the sub-queries as a final step?</description><ttl>30</ttl><generator>WEBDEV</generator><language>en_US</language><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/63452-wd22-reports-amp-queries-user-edition-sub-queries/read.awp</link><title>[WD22] Reports &amp;amp; Queries (user edition) - sub-queries</title><managingEditor>moderateur@pcsoft.fr (El moderador)</managingEditor><webMaster>webmaster@pcsoft.fr (El webmaster)</webMaster></channel></rss>
