1) That is a not strictly a join query
2) there is no relationship created between the orders and users tables.
your orders table should store the User ID. Instead of using the users.userID column in the where clause, use the orders.userID (or whatever the column is named in your orders table.