sql

bkvineet · #1 (**permalink**) 04-06-10, 10:35

hw foreign key and primary key related to each others

whats diff. b/w equi-joins&non equi-joins

pootle flump · #2 (**permalink**) 04-06-10, 10:40

What did you find when you looked up these terms?

r937 · #3 (**permalink**) 04-06-10, 13:22

Quote:

Originally Posted by bkvineet

hw foreign key and primary key related to each others

how?

they are related through the REFERENCES syntax of the foreign key declaration

Quote:

Originally Posted by bkvineet

whats diff. b/w equi-joins&non equi-joins

this is easy

equi-joins match rows based on some column values being equal, while non equi-joins match rows based on some column values ~not~ being equal