innerjoin
shoud be
inner join
and
pro.proid = ord.orderid
shoud it be ???
pro.proid = ord.proid
In addition, you cannot use 'order' as table name as it is a reserved word in mysql. But you can try using backticks ` to enclose it like these `order`, the backtick can be found on the top left hand side of your 101 keyboard. Do the same for the other tables.