An analyst needs a query that combines orders with customer names using their related customer identifiers. Which SQL operation is most appropriate?

1. JOIN
2. DELETE
3. BACKUP
4. GRANT