SQL hates SUMing the loads from PIREP table? [SOLVED]

[Kyle]

Hey,

I'm trying to make an query to get all of the passenger loads columns from the PIREP tables.

Here's the SQL Query i ran in our database manager

SELECT SUM(load) AS passengers FROM pireps

And I got the Query error...

#1064 - 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 'load) AS passengers FROM pireps' at line 1

Does anyone know why? I tried to sum the fuelused column and it worked, same query, but what the heck, why not to the loads column?

Hopefully someone can shine in!

[Parkho]

Are you trying to get the total pax carried? or you want pax of each pirep seperately?

[Kyle]

Are you trying to get the total pax carried? or you want pax of each pirep seperately?

Yep all in total.

[Guest lorathon]

Try this

SELECT SUM(`load`) AS passengers FROM pireps

[Kyle]

Try this

SELECT SUM(`load`) AS passengers FROM pireps

Thanks! That did the trick. . Forgot about the ` in the query.