SELECT 
	OrderLine_Status.Description + ' ' + MSL_Status.Description AS Status,
	Product.MSL_MSDesc,
	OrderLine.OrderQty,
	OrderLine.TotalCost,
	OrderLine.DespatchDateTime,
	OrderLine.DeliveryDateTime
	FROM OrderLine
	INNER JOIN OrderLine_Status ON OrderLine_Status.Status = OrderLine.Status
	INNER JOIN Product ON Product.ProductId = OrderLine.ProductId
	INNER JOIN MSL_Status ON MSL_Status.Action_code = OrderLine.Action_code
	WHERE (OrderLine.OrderRef = @OrderRef)[

quote:

---

Originally posted by mlawton40

Hi, I have the following select statement:

SELECT 
	OrderLine_Status.Description + ' ' + MSL_Status.Description AS Status,
	Product.MSL_MSDesc,
	OrderLine.OrderQty,
	OrderLine.TotalCost,
	OrderLine.DespatchDateTime,
	OrderLine.DeliveryDateTime
	FROM OrderLine
	INNER JOIN OrderLine_Status ON OrderLine_Status.Status = OrderLine.Status
	INNER JOIN Product ON Product.ProductId = OrderLine.ProductId
	INNER JOIN MSL_Status ON MSL_Status.Action_code = OrderLine.Action_code or OrderLine.Action_code IS NULL
	WHERE (OrderLine.OrderRef = @OrderRef)

But if the action code is null in my OrderLine table the sql does not display any rows.

Any help would be great!

---