Multiple Records, Only Want One

I have a query that returns multiple identical records, however it should
only return one. Indeed there is only one record for the OrderActionTypecode
of 'P' yet there are two orderactions so it returnd both.

Oddly the second query returns only the desired single record but wihtout
all the additional fields I need. Does the Inner join somehow mess with the
query?

Thanks

Query 1
SELECT Orders.OrderID, Orders.TicketID, A.AttemptID, E.EventID,
E.AssetCode AS Asset, Orders.FK_Prod_Alias AS Alias, Orders.ContractCode,
L.OrderLegCode AS OrderLeg, M.MarketActionName AS
Action, Orders.OrderVolume AS Volume, Orders.OrderPrice AS Price,
T.OrderTypeName AS OrderType, S.StatusName AS Status,
Orders.FilledVolume AS Filled, Orders.OriginalOrderDateTime,
Orders.PlaceOrderDateTime,
Orders.MonitorFlag
FROM Orders INNER JOIN
OrderAction OA ON Orders.OrderID = OA.OrderID INNER
JOIN
Attempt A ON Orders.AttemptID = A.AttemptID INNER JOIN
Event E ON A.EventID = E.EventID INNER JOIN
MarketAction M ON Orders.MarketActionCode =
M.MarketActionCode INNER JOIN
OrderLegs L ON Orders.OrderLegCode = L.OrderLegCode
INNER JOIN
OrderType T ON Orders.OrderTypeCode = T.OrderTypeCode
INNER JOIN
OrderState S ON Orders.Status = S.Status AND
Orders.OrderID =
(SELECT OrderID
FROM ORDERACTION
WHERE ORDERACTIONID =
(SELECT
MAX(ORDERACTIONID)
FROM
ORDERACTION
WHERE
OrderActionTypeCode = 'P'))


Query 2

SELECT OrderID, TicketID
FROM Orders
WHERE (OrderID =
(SELECT OrderID
FROM ORDERACTION
WHERE ORDERACTIONID =
(SELECT
MAX(ORDERACTIONID)
FROM
ORDERACTION
WHERE
OrderActionTypeCode = 'P')))