Question

Create a SQL query based on tblProducts and tblTransactionDetails that will display all the fields from tblProducts and the TransactionID and Quantity fields from tblTransactionDetails. Use a join to include all products, regardless of whether or not they have been purchased. Sort in ascending order by Brand. Save your query as qryTransactionDetails_initialLastn ame.

tblTransactionDetails

TransactionID	ProductID	Quantity
1	VZH159	2
2	EPP101	2
3	EOL672	3
4	VZH159	2
5	ZLE580	2

tblTransaction

TransactionID	CustomerID	EmployeeID	TransactionDate	MethodOfPayment
1	11	00078528	1/1/2015	Check
2	10	00078116	1/2/2015	Credit
3	6	00078116	1/3/2015	Cash
4	22	0007135	1/3/2015	Cash
5	9	00078116	1/4/2015	Credit
6	21	00016812	1/5/2015	Cash
7	18	00010099	1/6/2015	Cash
8	16	00016812	1/7/2015	Cash
9	2	00016356	1/8/2015	Cash
10	4	00078528	1/8/2015	Cash
11	10	00036096	1/8/2015	Check
12	13	00016812	1/9/2015	Credit
13	3	00066224	1/10/2015	Credit
14	2	00074823	1/11/2015	Check
15	26	00032877	1/12/2015	Cash
16	24	00016812	1/14/2015	Check
17	3	00078528	1/14/2015	Credit
18	7	00016812	1/14/2015	Check
19	6	00016812	1/14/2015	Cash
20	9	00066224	1/15/2015	Credit
21	16	00016812	1/16/2015	Check
22	21	00078528	1/16/2015	Check
23	5	0007135	1/17/2015	Cash

Answer 1

Query => select p.*, tT.TransactionID,tT.Quantity from tblProducts t LEFT JOIN tblTransactionDetails tT ON t.ProductID = tT.ProductID order by p.brand asc

explanation : Left join is instrumental in finding all the rows from the first table in Join irrespective of whether any connecting row is there in 2nd table.