Hello,

I'm running a trial version of YF 7.1 and I'm trying to create sub- queries with data from my db.

There is any limitation with Firebird 1.5 or Jaybird?

I would like to create an append sub-query to show in different columns the amount of seed bags produced in each year (2013 e 2014), just as the example of the sky team db...

Also tried inner join, but without success.

YF was installed with the native DB for evaluation in a windows 7, x64, and running the application on Firefox 34.0

Here is the SQL generated by YF:

SELECT
T0.C0,
T0.C1,
T1.C0
FROM (
SELECT DISTINCT
"CSLOTE"."IDCULTURA" AS C0,
SUM("CSLOTE"."NREMBALAGENS") AS C1
FROM "CSLOTE"
WHERE (
"CSLOTE"."YESAFRA" = 2013
)
GROUP BY
"CSLOTE"."IDCULTURA"

) T0
LEFT OUTER JOIN (
SELECT DISTINCT
SUM("CSLOTE"."NREMBALAGENS") AS C0,
"CSLOTE"."IDCULTURA" AS C1
FROM "CSLOTE"
WHERE (
"CSLOTE"."YESAFRA" = 2014
)
GROUP BY
"CSLOTE"."IDCULTURA"

) T1
ON T0.C0 = T1.C1