TransWikia.com

Creating Virtual Layer with only desired fields

Geographic Information Systems Asked on January 2, 2021

My question is very similar to this one. The difference being I want multiple fields where they wanted only a single field.

I’m trying to create a virtual copy of my layer with only the following fields:
"Acres", "Zoning", and "LinktoSOA".

I’ve tried these queries, but neither worked.

Select geometry, IN ["Acres", "Zoning", "LinktoSOA"]
from "WilmingtonParcels"
Select geometry, IN {"Acres", "Zoning", "LinktoSOA"}
from "WilmingtonParcels"
Select geometry, IN ("Acres", "Zoning", "LinktoSOA")
from "WilmingtonParcels"

One Answer

I found a solution.

Select geometry, "Acres", "Zoning", "LinktoSOA"
from "WilmingtonParcels"

enter image description here

Correct answer by Pfalbaum on January 2, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP