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) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291664 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
