This is the query
Code:
SELECT tblCards.[Card ID], tblCards.[Card Name], tblCards.[Category ID], tblCards.[Attribute ID], tblCards.[Monster ID], tblCards.Level, tblCards.[Attack Points], tblCards.[Defense Points], jctCardTypes.[Card ID], jctCardTypes.[Type ID], tblCards.[Pendulum Scale], tblCards.Link, tblCards.Description, tblCards.Forbidden, tblCards.Forbidden, tblCards.[File Name]
FROM lkpTypes INNER JOIN ((lkpMonsters INNER JOIN (lkpAttributes INNER JOIN (lkpCategories INNER JOIN tblCards ON lkpCategories.[Category ID] = tblCards.[Category ID]) ON lkpAttributes.[Attribute ID] = tblCards.[Attribute ID]) ON lkpMonsters.[Monster ID] = tblCards.[Monster ID]) INNER JOIN jctCardTypes ON tblCards.[Card ID] = jctCardTypes.[Card ID]) ON lkpTypes.[Type ID] = jctCardTypes.[Type ID];