| 1 |
6094
|
aaronmk
|
SELECT *
|
| 2 |
|
|
FROM "plotMetadata"
|
| 3 |
11993
|
aaronmk
|
LEFT JOIN
|
| 4 |
|
|
(
|
| 5 |
|
|
SELECT
|
| 6 |
|
|
"*party_code" AS "PrimOwnerID"
|
| 7 |
|
|
, event_participant_name AS "PrimOwnerID_name"
|
| 8 |
|
|
FROM party_code_party_
|
| 9 |
|
|
) AS "PrimOwnerID" USING ("PrimOwnerID")
|
| 10 |
11997
|
aaronmk
|
LEFT JOIN
|
| 11 |
|
|
(
|
| 12 |
|
|
SELECT
|
| 13 |
|
|
"*party_code" AS plot_administrator
|
| 14 |
|
|
, event_participant_name AS plot_administrator_name
|
| 15 |
|
|
FROM party_code_party_
|
| 16 |
|
|
) AS plot_administrator USING (plot_administrator)
|
| 17 |
6094
|
aaronmk
|
LEFT JOIN "lookup_MethodCode" USING ("MethodCode")
|
| 18 |
7625
|
aaronmk
|
;
|
| 19 |
|
|
|
| 20 |
|
|
ALTER TABLE :table ADD PRIMARY KEY ("PlotID");
|
