Two columns of a table join a column of another table how to write a SQL statement

f619424517 | browse 2,207 times recommended for 2016-09-09 11:38:18Best Answer

Select A.flightid,
A.flightname,
B.cityname,
C.cityname,
A.price,
A.cabinid,
A.time
From table 1 A, table 2 B, table 2 C
where A.origin=b.cityid
and A.finish=c.cityid

The first table is called Table 1, the second table is table 2, and table 2 takes two times, you just need to replace table 1 and table 2 with your actual name.

Two columns of a table join a column of another table how to write a SQL statement