Hello,
please make a table "Personen" in the embedded HSQL with this entries
ID Name hatChef
0 Kaiser
1 Müller 0
2 Schmidt 0
3 Klein 1
4 Groß 2
5 Schulte 1
6 Becker 2
Now define a query "reihung"
SELECT "mitarbeiter".*,"chef"."ID" AS "chefID","chef"."Name" AS
"chefName" FROM "Personen" AS "mitarbeiter", "Personen" AS "chef" WHERE
"mitarbeiter"."hatChef" = "chef"."ID"
and a query "crossjoin"
SELECT "mitarbeiter".*, "chef"."ID" AS "chefID","chef"."Name" AS
"chefName" FROM "Personen" AS "mitarbeiter" CROSS JOIN "Personen" AS
"chef" WHERE "mitarbeiter"."hatChef" = "chef"."ID"
Please use only sql-view. Design-view will not work! (Issues 73627, 76374)
I expect, that the queries have the same results, but they don't have.
What do I miss?
kind regards
Regina
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
