Question

Write a basic SQL query that lists all orders with customer information.

Answer 1

Usually, we have order tables and customer tables that contain the following columns:

• Order Table 
• Orderid
• customerId 
• OrderNumber
• TotalAmount
• Customer Table 
• Id
• FirstName
• LastName
• City 
• Country  
• The SQL query is:
• SELECT OrderNumber, TotalAmount, FirstName, LastName, City, Country
• FROM Order
• JOIN Customer
• ON Order.CustomerId = Customer.Id