Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Table intersection?

Status
Not open for further replies.
SMAlvarez

SMAlvarez

Programmer
Dec 4, 2005
27
US
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.
 
Sort by date Sort by votes
the intersection of the two tables consists of those rows which have the same values in corresponding columns

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
 
Upvote 0 Downvote
u had 3 join attributes...
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.



 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

harfri
  • Locked
  • Question
Insert into a new table
Replies
0
Views
289
harfri
harfri
mikrom
  • Locked
  • Question
from a table with symmetric relation select every pair only once
Replies
0
Views
290
mikrom
mikrom
Davest11
  • Locked
  • Question
Table or View does not exist
Replies
11
Views
546
PHV
PHV
jasonhuibers
  • Locked
  • Question
Delete Attachments for Table
Replies
2
Views
260
jasonhuibers
jasonhuibers
barnettjacob
  • Locked
  • Question
SQL Query - Summarise Data from 2nd table 2
Replies
8
Views
383
r937
r937

Part and Inventory Search

Sponsor

Back
Top