Since RN occurs in both tables, perhaps you need to include the table name in the Select in front of RN, e.g. Select SurfaceWaterUsage.RN, n_use_amt...
On Fri, Aug 25, 2006 at 02:58:43PM +0800, Data Directions wrote: > View tables are great, if you can get them working! > > When I try to run the following View Table, I get an error message saying > Bore_Total_Water_Usage:11: Numeric values required. Any ideas? Thanks. Bill > > > !table > !version 100 > Open Table "SurfaceWaterUsage" Hide > Open Table "T-WaterBores" Hide > > Create View Bore_Total_Water_Usage As > Select RN, n_use_amt > From SurfaceWaterUsage, T-WaterBores > Where SurfaceWaterUsage.RN = T-WaterBores.RN > > > > _______________________________________________ > MapInfo-L mailing list > [email protected] > http://www.directionsmag.com/mailman/listinfo/mapinfo-l > _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
