|
|
| Query name | Field name | Field type | Source table | Source field |
|---|---|---|---|---|
| address_complete | firstname | VARCHAR | a | firstname |
| ID | INTEGER | a | ID | |
| lastname | VARCHAR | a | lastname | |
| number | VARCHAR | a | number | |
| postcode_ID | INTEGER | a | postcode_ID | |
| street | ( SELECT "street" FROM "street" WHERE "ID" = "a"."street_ID" ) | |||
| street_ID | INTEGER | a | street_ID | |
| town | ( SELECT "postcode"."postcode" || ' ' || "town"."town" FROM "postcode", "town" WHERE "town"."ID" = "postcode"."town_ID" AND "postcode"."ID" = "a"."postcode_ID" ) |