HI,
I HAVE A CHART WITH FOLLOWING MYSQL
SELECT
id,
usd_per_kilo,
usd_45,
usd_100,
usd_300,
usd_500,
usd_1000,
airline,
frequency,
routing,
tranit_time,
connect
FROM rates
I Have a master/details relationship where connect from table rates ( child table) is connected to master table routing (see below table details)
SELECT id,
origin_airport,
destination_airport,
origin_country,
destination_country,
date
FROM routing
I copy the chart above the child detail table and i need to see only data related to child details not all .
pls help