peskywinnets
Registered User.
- Local time
- Today, 23:44
- Joined
- Feb 4, 2014
- Messages
- 576
To avoid a ridiculously long SQL Select statement, how do I select all record from two tables?
So in the example below, I've two tables [Customers] & [Invoice] which are joined by CustomerID
...but rather than nominate each record individually, I want all records from both tables in the select statement.
Couldn't locate the syntax via google!
So in the example below, I've two tables [Customers] & [Invoice] which are joined by CustomerID
Code:
SELECT Customers.BillingName, Invoice.InvoiceNumber, Customers.BillingAddress1, Invoice.OrderDateTime
FROM Customers INNER JOIN Invoice ON Customers.CustomerID = Invoice.CustomerID;
...but rather than nominate each record individually, I want all records from both tables in the select statement.
Couldn't locate the syntax via google!