query 5 Write an SQL statement to list LastName, FirstName, and Phone of the customers who made the purchases with SaleIDs 1, 2, and 3. Use a subquery.

Select C.LastName, C.FirstName, C.Phone from dbo.CUSTOMER C, dbo.SALE S Where C.CustomerID = S.CustomerID and S.SaleID in (1, 2, 3);

Query 6 Answer part I but use a join using JOIN ON syntax. What are the consequences of using (or not using) the DISTINCT keyword in this version of the query?

how would i use the join on with this query