[RESOLVED] MySQL syntax error

[bczm8703]

hi.. i am trying to do a INSERT, SELECT and inner join statement together and i received this error..

My SQL syntax

INSERT INTO TableSalesReportMU (AirWayBillNumber, FlightDate, DepartureFrom, Destination, Via1, GrossWt, ChargeableWt, Prepaid, TotalPrepaid, FreightCollect, Comm, DueAgent, Fuel, Security, Others, DueCarrier, FreightDue, Discount, CarrierRate, Airline, IATARate, DGR ) SELECT TableAWBDetails.AirWayBillNumber, TableAWBDetails.FlightDate, TableAWBDetails.DepartureFrom,TableAWBDetails.Destination, TableAWBDetails.Via1, TableAWBDetails.GrossWeight, TableAWBDetails.CostingChargeableWeight,
                TableAWBDetails.Prepaid, TableAWBDetails.TotalPrepaid, TableAWBDetails.FreightCollect, TableAWBDetails.Comm,
                TableAWBDetails.DueAgent, TableAWBDetails.Fuel, TableAWBDetails.Security, TableAWBDetails.Others,
                TableAWBDetails.DueCarrier, TableAWBDetails.FreightDue, TableAWBDetails.Discount, TableAWBDetails.CarrierRate
                TableAWB.Airline, TableAWBDetails.IATARate, TableAWBDetails.DGR FROM (TableAWB INNER JOIN TableAWBDetails ON TableAWB.AirWayBillNumber = TableAWBDetails.AirWayBillNumber)
                WHERE TableAWB.Airline='MU' and TableAWBDetails.Report = 'MU' AND (TableAWB.Costing <> 0 or TableAWBDetails.Destination = 'CNX')
AND TableAWBDetails.FirstHalf = True AND Month = 'June' AND Year = '2011'

error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version 
for the right syntax to use near '.Airline, TableAWBDetails.IATARate, TableAWBDetails.DGR FROM (TableAWB INNER JOI' at line 5

Table Datatype:

TableAWB:


TableAWBDetails:



TableAWBDetails Cont:


TableSalesReportMU


Uploaded with ImageShack.us
i am using MySQL server 5.5