| address_complete |
name_correlated_subquery (Form)
name_tablecontrol (Form) |
SELECT |
Details |
SELECT
"a".*,
(
SELECT
"street"
FROM
"street"
WHERE
"ID" = "a"."street_ID") "street",
(
SELECT
"postcode"."postcode" || ' ' || "town"."town"
FROM
"postcode",
"town"
WHERE
"town"."ID" = "postcode"."town_ID"
AND "postcode"."ID" = "a"."postcode_ID") "town"
FROM
"name" AS "a" |
