Table intersection?
Table intersection?
(OP)
Hey,
Let's say we have two table both the fields "first name", "last name", and "address".
Which of these fields intersect? I mean don't all three intersect since there common to both tables? Or is this some special property for two tables to intersect other then them having the same field? Thanks.
Let's say we have two table both the fields "first name", "last name", and "address".
Which of these fields intersect? I mean don't all three intersect since there common to both tables? Or is this some special property for two tables to intersect other then them having the same field? Thanks.
RE: Table intersection?
you can obtain the intersection using the INTERSECT operator, but, in practice, not all database systems support this operator, so you can achieve the same results with an inner join
r937.com | rudy.ca
Buy my new book Simply SQL from Amazon
RE: Table intersection?
u should write an inner join for all these 3 colums...
if u have primary key in 1 table and forign key in another table...u can simply applyinner join on key column only.