MSSQL to MySQL

[Kadesh Bailey]

I have this query:
SELECT *,
(Select ItmName From Items Where Items.RecordID = ItemID) as ItemName,
(Select CategoryID From Items Where Items.RecordID = ItemID) as CategoryID,
(Select ClientID From Items Where Items.RecordID = ItemID) as ClientID,
(Select CatName From Categories Where Categories.RecordID in (Select CategoryID From Items Where Items.RecordID = ItemID)) as CategoryName,
(Select FName + ' ' + LName From Clients Where Clients.RecordID in (Select ClientID From Items Where Items.RecordID = ItemID)) as ClientName,
(Select ItmName From ItemTypes Where ItemTypes.REcordID in (Select ItmType From Items Where Items.RecordID = ItemID)) as ItemTypeName,
(Select RecordID From ItemTypes Where ItemTypes.REcordID in (Select ItmType From Items Where Items.RecordID = ItemID)) as ItemTypeID

FROM Offers
ORDER BY DteAdded DESC


Please help me fix it...I don't know what I need to do...I'm searching everywhere and all sites say that MySQL supports subselects/subqueries...but I keep getting an error telling me that I need to check the syntax