dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Tip: Fetching Common Records Between Two Tables

See how to fetch records that are common to one or more tables.


advertisement

You can fetch records that are common to one or more tables by using INTERSECT. Here is a small example:

Select * from Employees

Intersect

Select * from RetiredEmployees

 

Visit the DevX Tip Bank

 



   
Thanks for your registration, follow us on our social networks to keep up-to-date