At 5:10 When I Run the Query is tells me "The specified field [UnitPrice] could refer to more than one table listed in the FROM clause of your SQL statemnt." I understand that [UNITPRICE] is in two tables but I thought I had followed the lessons exactly.  Do you not have the [UNITPRICE] in OrderDetailT and ProductT?  If so, what is my solution to fix that error?  thanks
SQL view = SELECT OrderT.OrderDate, [Quantity]*[UnitPrice] AS LineTotal, OrderT.IsPaid
FROM (OrderT INNER JOIN OrderDetailT ON OrderT.OrderID = OrderDetailT.OrderID) INNER JOIN ProductT ON OrderDetailT.ProductID = ProductT.ProductID
WHERE (((OrderT.IsPaid)=True));

---

Reply from Rick Rost:

Hi Vicki.

If you have the same field in multiple tables you would need to specify which table you want to pull the value from, in this case either OrderDetailT.UnitPrice or ProductT.UnitPrice