Join tables in SQL Forms?

From: mark ross <ross_at_suntarget1.dab.ge.com>
Date: Wed, 14 Apr 1993 00:08:30 GMT
Message-ID: <1993Apr14.000830.3985_at_ge-dab.GE.COM>

I am trying to build a database based on the Federal Express tracking system. (Much smaller scale of course!) So far my database contains only two tables. The first is for information about the individual stations:

	city,
	state,
	city_id

The second table contains information about the vehicles delivering the packages:

	vehicle_departed_from_id,
	current_location_id,arrival_time,departure_time
	destination_city_id,dest_arrival_time
	vehicle_id_number

Somehow I have to be able to track each package, and give a route for each package based on the departure time, departure city and destination.

My question is, how can I join these two tables so that I will have a useful block of information. I want to be able to scroll up and down the list displaying information from both tables for each entry. i.e.

	city, state, city_id, vehicle_departed_from_id
	city, state, city_id, current_location_id, arrival_time, departure_time
	city, state, city_id, destination_city_id, dest_arrival_time

Also, I have an Ada program that will find the path for a package, but I don't know how to get the program to read the database. Is there an easier way to do this using forms, or should I take the Ada route? In either case, how would I do it?

My apologies for my rather long winded question, and lack of knowledge in this area. Needless to say, I am just starting out in this!

Thank you in advance

        Mark Ross

---

      Mark I. Ross
      Simulation & Control Systems       ross_at_sunny.dab.ge.com
      Daytona Beach, Florida                  
      (904)239-2197


____________________________________________________________________

Received on Wed Apr 14 1993 - 02:08:30 CEST