how to get data from two tables in mysql query with where Pk of one table is set as foreign key on PK column for other table?
Well, your orders table doesn't have a column orderaccid. You can use using only when the column names are equal. Use this instead: 

from orderacc join orders on orderacc.orderaccid = orders.orderid