Hello Everyone,
Ok here goes. I have 2 tables 't_car' and 't_owner'.
#
't_car'
pk_vin
make
fk_owner

't_owner'
pk_ownerid
fname
lname

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.
(ex...'fname','lname').
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
http://finance.yahoo.com