The example below shows the specification of a multi-table join being performed during reading from the SpatialWare database. The user specifies the tables upon which the query is to be performed in the <sqlStatement> clause as well as how the tables are to be combined to select the features to read. The feature type assigned to the feature in this example is REPLICATION.
MACRO TOWN LosAngeles SPATIALWARE_DATASET testdset
SPATIALWARE_SERVER_VERSION 4.8 SPATIALWARE_SERVER_TYPE sqlserver SPATIALWARE_USERID kevin
SPATIALWARE_PASSWORD secret
SPATIALWARE_DEF REPLICATION SELECT * \
FROM REPLICATION, DIST_CENTER, REPLICATION_LAYERS \
WHERE \
REPLICATION.REPLICATION_DATE IS NULL AND \
REPLICATION.AREA_CD = DIST_CENTER.AREA_CD AND \
REPLICATION.IDENT = REPLICATION_LAYERS.IDENT AND \
DIST_CENTER.TOWN_CD = $(TOWN)