Key-ins for Joins
Joins can be created by using key-ins as below:
- MAP JOIN ADD feature1.property1=feature2.property2 — Adds a join between feature 1 and feature 2. Note that the feature and property names are case senstive.
- Example: map join connect Hydrants.WmainID=Watermains.WmainID
- MAP JOIN CLEAR — Removes all joins.
- MAP JOIN CONNECT <filename> — Establishes a connection to the specified file such as a SHP or VRT file. This key-in is typically follwed by the MAP JOIN ADD key-in.
- Example: map join connect d:\shp\watermains.shp
- Example: map join connect d:\imports\watermains.vrt
- MAP JOIN REMOVE feature1.property1=feature2.property2 — Removes the specified join. The key-in should respect f1.p1=f2.p2 format. Note that the feature and property names are case senstive. In addition, f1 must always be specific, while wild cards can be used for other parameters.
- Example: map join remove Hydrants.WmainID=Watermains.WmainID .
- Example: map join remove Hydrants.*=*.*
- MAP JOIN SHOW — Opens the Defines Joins dialog and selects the left and right side features as the first feature found.