Re: MSSQL to MySQL

[Kadesh Bailey]

how do I deal with the situation when "INNER JOIN Items AS i ON i.RecordID = o.ItemID " is another subquery?

I am trying to rewrite like this:
SELECT *,
Items.ItmName as ItemName,
Items.CategoryID as CategoryID,
Categories.CatName as CategoryName,
concat(Clients.FName, ' ', Clients.LName, ' (', Clients.Handle, ')') as ClientName,
ItemTypes.ItmName as ItemTypeName,
ItemTypes.RecordID as ItemTypeID
From OfferResponses

Inner Join items on Items.RecordID = OfferResponses.ItemID
Inner Join Categories on Categories.REcordID in (Select CategoryID From Items Where Items.RecordID = OfferResponses.ItemID)
Inner Join Clients on Clients.RecordID in (Select ClientID From Items Where Items.RecordID = OfferResponses.ItemID)
Inner Join ItemTypes on ItemTypes.RecordID in (Select ItmType From Items Where Items.RecordID = OfferResponses.ItemID)
ORDER BY OfferResponses.OfferDte DESC


The Inner Join that has the subquery is returning an error but how do I get that value????

I'm sorry if this is an obvious easy question - I'm...well...new! :)