Highlights
All Snippets
Top 100 Snippets
Librarians
gbCodeLib

By Language
VB6
JavaScript
Perl
HTML
SQL
Java
DOS

GBIC >> Source Code >> SQL >> Snippet

INTERSECT


use OF INTERSECT -  returns ONLY the ROWS FOUND by BOTH queries
SELECT NAME   FROM customers INTERSECT   SELECT NAME FROM friends