SELECT *

FROM "plotMetadata"

LEFT JOIN "lookup_MethodCode" USING ("MethodCode")

ALTER TABLE :table ADD PRIMARY KEY ("PlotID");