wat if there is no foren key is not there

[seshu]

yes guys this is my problem
i have seen two tables like this
t1 with columns (roll-int,eng-int,maths-int,sceinces-int)
t2 with columns (name-char, father-char,mother-char,)
now here the roll no in t1 are of names in t2 but how to join them


t1 with columns (roll-int,eng-int,maths-int,sceinces-int)
t2 with columns (roll-int,name-char, father-char,mother-char,)
and here i want a tble with coll(rool-int,name-char,eng-int,maths-int,sceinces-int)
making roll as primary key and one more thing third table has to be in mysql database

[ronverdonk]

Since there is not a single thread of a relation between the two tables (in your first set) you cannot join them on the basis of common columns.

And is the 2nd set of tables shown a result of what you want to accomplish or another set of tables? How do you get roll into table 2?

Or do I completely misunderstand your problem (what is the actual question??). So please elaborate.

Ronald :cool: