Hi there I have a query that I have created - it works against a MS-Access database but does not work with MySQL. I have searched through the MySQL notes that I have but cant find out why - I think its because of the AS MatTotal section of the query.
Thanks in advance for feedback SELECT visaudactweight.RecID, Sites.SiteName, visaudactweight.VADateTime, CompanyNames.CompanyName, GateKeeperRecs.RegoNo, GKeeperNames.GKeeperName, AuditorNames.AuditorName, GateKeeperRecs.NetWeight, (visaudactweight.Asphalt + visaudactweight.Cardboard_CompactedDry + visaudactweight.Cardboard_CompactedWet + visaudactweight.Cardboard_LooseDry+ visaudactweight.Cardboard_LooseWet + visaudactweight.Cardboard_Waxed + visaudactweight.Clay + visaudactweight.CleanFill + visaudactweight.Concrete+ visaudactweight.Food_Kitchen + visaudactweight.Garbags + visaudactweight.Glass + visaudactweight.Leather_Textiles + visaudactweight.Leather_TextilesFurn + visaudactweight.Leather_TextilesMatt + visaudactweight.Leather_TextilesCar + visaudactweight.Metal_Ferrous + visaudactweight.Metal_NonFerrous + visaudactweight.Paper + visaudactweight.Plastic_BagsFilm + visaudactweight.Plastic_Hard + visaudactweight.PlasterBoard + visaudactweight.Polystyrene + visaudactweight.Rocks_Bricks + visaudactweight.Rubble + visaudactweight.Soil+ visaudactweight.Tyres_Rubber + visaudactweight.Vegetation_Garden + visaudactweight.Wood_Timber + visaudactweight.Wood_Pallets + visaudactweight.Wood_Fencing + visaudactweight.Wood_Furniture + visaudactweight.Other_CD + visaudactweight.Other_CI + visaudactweight.Hazardous) AS MatTotal, ((MatTotal - GateKeeperRecs.NetWeight)/GateKeeperRecs.NetWeight)*100 as PercentDiff FROM visaudactweight, Sites, AuditorNames, CompanyNames, GateKeeperRecs, GKeeperNames WHERE (((((visaudactweight.SiteID = Sites.SiteID) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291660 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
