1) Comma missing after
from CUSTOMER,BRANCH,Order
this might explain the syntax error.

2) No join conditions on BRANCH and CUSTOMER => Cartesian product. I doubt if you want that.

3) It doesn't make sense to me, not to have Branch.Branch_ID in the Select clause - how do you know which result row referrs to which group?