write a SQL query to return a list of all the invoices. For each invoice, show the Invoice ID, the billing date, the customer’s name, and the name of the customer who referred that customer (if any). The list should be ordered by billing date.
// Invoices SELECT TOP (1000) [Id] ,[BillingDate] ,[CustomerId] FROM [eNtsaRegistration].[dbo].[Invoices] // Customers SELECT TOP (1000) [Id] ,[Name] ,[ReferredBy] FROM [eNtsaRegistration].[dbo].[Customers]
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)