sql syntax for creating a new table out of multiple large tables
===

I am new to MySql and sql. 
i can't figure out how to do the following:

i have a bus schedule database with four relevant _tables_:

    stops (24,403 rows)
    -------------------
    stop_id   int(11)


    stopTimes (12,073,459 rows)
    ---------------------------
    stop_id   int(11)
    trip_id   varchar(30)


    trips (320,395 rows) 
    ---------------------------
    trip_id   varchar(30)
    route_id  int(11)


    routes (9,748 rows)
    ---------------------------
    route_id            int(11)
    agency_id           int(11)	 	 	 	 	 	
    route_short_name	varchar(10)


**relations**

 - **routes to trips:** one to many
 - **trips to stopTimes:** one to many
 - **stops to stopTimes:** one to many


out of these tables i would like to create a new table "routeStops" with the following fields:


    routeStops (~100,000 rows)
    ---------------------------
    route_id            int(11)
    agency_id           int(11)	 	 	 	 	 	
    route_short_name	varchar(10)
    stop_id   int(11)

with a one to many relationship between it and the stops.

is there an **SQL query** that can perform that?

should i add an index  to the **route_id** and **stop_id** to optimize performance? should i add a fulltext index to trip_id?

i am new to that and will appreciate some insights.

i am using PHPMyAdmin and a rather new XAMPP installation.

tnx,
