Make the query like this:

SELECT C.*, A.FlagID, B.Flag, B.FlagDescription, D.Target

FROM PositionFlags AS A

INNER JOIN Flags AS B

ON B.ID = A.FlagID

INNER JOIN Positions AS C

ON C.ID =...