0 votes
in Data Science by
Write a basic SQL query that lists all orders with customer information.

1 Answer

0 votes
by

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

Related questions

0 votes
asked Jan 21 in Oracle by rajeshsharma
+1 vote
asked Jul 10, 2020 in Sql by SakshiSharma
...