How to select multiple data from SQL from multiple tables?

Question

SQL

tables

in it

The challenge is to do this in 1 sql query.
Problem. I can't join 2 tables. I can't bind by order_id - username and total_price.
qty - an arbitrary number, it shows the number of goods.

SELECT * FROM `order_products` INNER JOIN `orders` ON order_id = orders.id ОТВЕТ (ну у меня работает так)

Answer 1

Your question sounds like a task, and no one will do it for you. First, show your request, and maybe they will help you find the error.