CREATE TABLE Flight (aid VARCHAR2, flno VARCHAR2)
CREATE TABLE Aircraft (name VARCHAR2, aid VARCHAR2)

What is the aircraft name for the flight with number 99
SELECT T2.name FROM Flight AS T1 JOIN Aircraft AS T2 ON T1.aid = T2.aid WHERE T1.flno = 99
SELECT "T2"."name" FROM "Flight" "T1" JOIN "Aircraft" "T2" ON "T1"."aid" = "T2"."aid" WHERE "T1"."flno" = 99