Skip to content
Advertisement

Sql query to select several items from a another table in relation to values on a single row of a table

These are my two tables, wish do a mysql query to return: id_order,qty,id_user as name1 and updatedby as name2. I’ve tried this query but not working:

Advertisement

Answer

Use this.

See the demo here: DB-Fiddle

User contributions licensed under: CC BY-SA
3 People found this is helpful
Advertisement