Two columns in one table are displayed with results associated with a column in another table

Station table

Column Name:

StationId-----Site Number

Stationlon----Site Longitude

Stationlat----Site Latitude

Record table

Column Name:

Recorkid---------Record number

stationgoid------Lending a site number

Stationbackid----Return the site number

Query Results Display columns:

Stationgoid-----Lending a site number

Gostationlon----Loan Site Longitude

Gostationlat----Lending a site latitude

Stationbackid---Return the site number

backstationlon--return site Longitude

Backstationlat---Return the site latitude

1 SelectR.stationgoid,s1.stationlon asGostationlon,s1.stationlat asGostationlat,2R.stationbackid,s2.stationlon asBackstationlon,s2.stationlat asBackstationlat3  fromRecord asR,station asS1,station asS24 whereR.stationgoid=S1.stationid andR.stationbackid=S2.stationid

SQL query Results:

Two columns in one table are displayed with results associated with a column in another table