Database linking
Posted by: code fun
Date: October 17, 2007 09:30AM

hi
i have a small database and want to make tables such that if I call only the id from another table the remaining data in the second table is accessed by the first.
for example:
tblcombination has
+--------+
|id |
|detail1 |
|detail2 |
+--------+

and tbldetail is
+---------+
|id |
|name |
|detail |
|type |
|quantity |
+---------+

if these are innoDB tables is it sufficient to define foriegn keys? if so how?
and how do I access the data?

Options: ReplyQuote


Subject
Written By
Posted
Database linking
October 17, 2007 09:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.