You can start by using this:
SELECT "Customer"."FullName", "SalesOrderLIne"."SalesOrderLIneItemRefFullName", "SalesOrderLIne"."SalesOrderLIneQuantity", "SalesOrderLIne"."SalesOrderLIneDesc", "SalesOrderLIne"."SalesOrderLIneAmount", "SalesOrderLIne"."SalesOrderLIneItemRefFullName", "SalesOrderLIne"."SalesOrderLIneClassRefFullName", "SalesOrderLIne"."SalesOrderLIneRate", "ItemInventory"."PurchaseCost", "ItemInventory"."AverageCost", ("SalesOrderLIne"."SalesOrderLIneQuantity" * "ItemInventory"."AverageCost") as TotalAvgCost FROM "Customer" "Customer","SalesOrderLIne" "SalesOrderLIne", "ItemInventory" "ItemInventory" WHERE ("SalesOrderLIne"."CustomerRefListID"="Customer"."ListID") AND ("SalesOrderLIne"."SalesOrderLIneItemRefListID" = "ItemInventory"."ListID")
|