query problem - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

query problem

Author

Topic

Keshaba
Yak Posting Veteran

52 Posts

Posted - 2010-11-11 : 05:38:04

I am using mysql .I have made a query which works fine in sql server 2005 express.But I am facing problem in running the same in mysql.

my sql query is:


SELECT     flight_ops_transaction.Airlines,flight_ops_transaction.Sectors,flight_ops_transaction.Day_of_week,flight_ops_transaction.sDate,
                      flight_ops_transaction.Flightno,flight_ops_transaction.ATA,flight_ops_transaction.ATD,flight_ops_transaction.Remarks,
                      manpowertransaction.loaders,manpowertransaction.drivers,manpowertransaction.supervisor,manpowertransaction.techincian,
                      manpowertransaction.vallet,equipmenttransaction.Baagage_trolley_closed,equipmenttransaction.Baagage_trolley_open,
                      equipmenttransaction.BatteryCart,equipmenttransaction.BFL,equipmenttransaction.FireExtinguisher,
                      equipmenttransaction.RampCoach_nonac,equipmenttransaction.RampCoach_ac,equipmenttransaction.RampCoach_mini,
                      equipmenttransaction.stepladder,equipmenttransaction.tata207,equipmenttransaction.toiletcart,equipmenttransaction.tractor,
                      equipmenttransaction.watercart,equipmenttransaction.wheelchair,equipmenttransaction.vaccumcleaner,
                      manpowertransaction.Remarks_ref, remarks_manpower.ManpowerType,remarks_manpower.RemarksOnmanpower,
                      remarks_equipment.Remarks_ref_equipment,remarks_equipment.ManpowerType_equipment,
                      remarks_equipment.Remarksonequipment
FROM         flight_ops_transaction FULL OUTER JOIN
             equipmenttransaction INNER JOIN
             remarks_equipment ON equipmenttransaction.Remarks_ref = remarks_equipment.Remarks_ref_equipment ON
                      flight_ops_transaction.Airlines = equipmenttransaction.Airlines AND
                      flight_ops_transaction.Sectors = equipmenttransaction.Sectors AND
                      flight_ops_transaction.Day_of_week = equipmenttransaction.Day_of_week AND
                      flight_ops_transaction.sDate = equipmenttransaction.sDate FULL OUTER JOIN
                      manpowertransaction INNER JOIN
                      remarks_manpower ON manpowertransaction.Remarks_ref = remarks_manpower.Remarks_ref ON
                      flight_ops_transaction.Airlines = manpowertransaction.Airlines AND
                      flight_ops_transaction.Sectors = manpowertransaction.Sectors AND
                      flight_ops_transaction.Day_of_week = manpowertransaction.DayOfweek AND
                      flight_ops_transaction.sDate = manpowertransaction.mDate

The error message I am getting is
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 'OUTER JOIN
equipmenttransaction INNER JOIN
remarks_e' at line 12

Can any body help

This is the line I guess where I am having problem
FROM flight_ops_transaction FULL OUTER JOIN
equipmenttransaction INNER JOIN

Keshab

pk_bohra
Master Smack Fu Yak Hacker

1182 Posts

Posted - 2010-11-11 : 05:56:55

May be

quote:

FROM flight_ops_transaction FULL OUTER JOIN
equipmenttransaction ON <followed by join condition> INNER JOIN

pk_bohra
Master Smack Fu Yak Hacker

1182 Posts

Posted - 2010-11-11 : 05:58:04

Also try posting the question at:
www.dbforums.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources