CREATE TABLE college (Name VARCHAR2, College_ID VARCHAR2)
CREATE TABLE member (Name VARCHAR2, College_ID VARCHAR2)

Show the names of members and names of colleges they go to.
SELECT T2.Name, T1.Name FROM college AS T1 JOIN member AS T2 ON T1.College_ID = T2.College_ID
SELECT "T2"."Name", "T1"."Name" FROM "college" "T1" JOIN "member" "T2" ON "T1"."College_ID" = "T2"."College_ID"