select tecmoplayer.*, player_atts.*, tttID, ttCity, ttName from player_atts, tecmoplayer, standings where pUID =  AND pUID = pID AND pttUID = ttTecmoOrder AND plUID = ttlUID AND plUID = 2 AND psUID = 1994 AND tttID = ptttID AND psUID = ttsUID