www.hkvforums.com

I create a view and I want to remove the duplication record from my view. This is the sql code for my view

SELECT
policy.PanelName,
invoice.Invoice_ID,
invoice.Invoice_Date,
inventorybrand.BrandName,
inventory.Panel_Price,
billingitem.Name,
visit_billing.Price
FROM
invoice INNER JOIN
medicinelist ON invoice.VisitID = medicinelist.VisitID INNER JOIN
visit_billing ON invoice.VisitID = visit_billing.VisitID INNER JOIN
policy ON policy.EcPolicyID = invoice.Panel INNER JOIN
inventory ON inventory.InventoryID = medicinelist.InventoryID INNER JOIN
inventorybrand ON inventorybrand.BrandID = inventory.BrandID INNER JOIN
billingitem ON billingitem.BillingItemID = visit_billing.BillingItemID

I want to remove duplcation record on billingitemid

You may Google "select distinct" for your references.