Relationship between two tables.

[linux1880]

Hi all,

 

If there are a two tables in a database with primary key are they in relationship without needing to add foreign keys ?

 

I was doing

select col1, col2 from table1,table 2

it just fetch two coluns from two different tables. There was no fk.

 

Is that possible ?

[V]

You'll have to use something like this

 

"SELECT table1.col1, table2.col2 FROM table1, table2"

 

and you can use WHERE to make the relationship.

 

"SELECT table1.col1, table2.col2 FROM table1, table2 WHERE table1.some_id = table2.some_id"