Custom Command Sample

The following is an example of a custom command:

SELECT Client.Company, Client.Contact, Client.Address1, Client.Address2, Client.City, Client.State_Prov, Client.Country, Client.PostalCode, Invoice.Inv_Number, Invoice.Inv_Date, Invoice.Ship_Date, Invoice.Inv_Total, Invoice.Date_Paid FROM Client INNER JOIN Invoice ON Client.ClientID = Invoice.ClientID ORDER BY Client.Company;