CREATE TABLE table_name_28 (affiliation VARCHAR, mls_team VARCHAR, pick__number VARCHAR)

Tell me the affiliation for mls team of metrostars and pick number of 26
SELECT affiliation FROM table_name_28 WHERE mls_team = "metrostars" AND pick__number = 26
SELECT "affiliation" FROM "table_name_28" WHERE "metrostars" = "mls_team" AND "pick__number" = 26