CREATE TABLE aircraft (aid NUMBER, name CLOB, distance NUMBER)
CREATE TABLE certificate (eid NUMBER, aid NUMBER)
CREATE TABLE flight (flno NUMBER, origin CLOB, destination CLOB, distance NUMBER, departure_date TIME, arrival_date TIME, price NUMBER, aid NUMBER)
CREATE TABLE employee (eid NUMBER, name CLOB, salary NUMBER)

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"