Java Reference
In-Depth Information
The complete query for the report is:
select
a.tail_num,
a.aircraft_serial,
am.model as aircraft_model,
ae.model as engine_model
from aircraft a, aircraft_models am, aircraft_engines ae
where a.aircraft_model_code = am.aircraft_model_code
and a.aircraft_engine_code = ae.aircraft_engine_code
and ae.horsepower >= 1000
The following window shows a list of all columns selected in the query, allowing us
to select which ones we would like to use as report fields:
In this case, we want the data for all columns in the query to be displayed in the
report. Therefore, we select all columns by clicking on the button labeled
>>
.
