Subject Interbase DB Design Question...newbie zone.....
Author Derek Basch
Hello Everyone,
Ok here goes. I have 2 tables 't_car' and 't_owner'.


fk_owner refrences pk_ownerid

Now, I query 'select * from t_car'. I get in return
the car vin #, car make and the foreign key value of
the car owner.
I understand how to use the foriegn key referential
contraint to refer to the 'pk_ownerid' in the owner
table. What I dont understand is how to get the values
associated with that foriegn key.
So, here is the question, how do I get a cars vin #
and the associated owners first name and last name?
Thanks for the help,
Derek T Basch
Portland OR

Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes