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

Show all flight numbers with aircraft Airbus A340-300.
SELECT T1.flno FROM Flight AS T1 JOIN Aircraft AS T2 ON T1.aid = T2.aid WHERE T2.name = "Airbus A340-300"
SELECT "T1"."flno" FROM "Flight" "T1" JOIN "Aircraft" "T2" ON "Airbus A340-300" = "T2"."name" AND "T1"."aid" = "T2"."aid"