Edit Question - KnowledgeHub

Title Body

I'll use a concrete, but hypothetical, example. Each Order normally has only one line item : Orders: OrderGUID OrderNumber ========= ============ {FFB2...} STL-7442-1 {3EC6...} MPT-9931-8A LineItems: LineItemGUID Order ID Quantity Description ============ ======== ======== ================================= {098FBE3...} 1 7 prefabulated amulite {1609B09...} 2 32 spurving bearing But occasionally there will be an order with two line items: LineItemID Order ID Quantity Description ========== ======== ======== ================================= {A58A1...} 6,784,329 5 pentametric fan {0E9BC...} 6,784,329 5 differential girdlespring Normally when showing the orders to the user: SELECT Orders.OrderNumber, LineItems.Quantity, LineItems.Description FROM Orders INNER JOIN LineItems ON Orders.OrderID = LineItems.OrderID I want to show the single item on the order. But with this occasional order containing two (or more) items, the orders would appear be duplicated : OrderNumber Quantity Description =========== ======== ==================== STL-7442-1 7 prefabulated amulite MPT-9931-8A 32 spurving bearing KSG-0619-81 5 panametric fan KSG-0619-81 5 differential girdlespring What I really want is to have SQL Server just pick one , as it will be good enough : OrderNumber Quantity Description =========== ======== ======

Tags (comma-separated) Cancel