Sub-SELECT’s

• If data from one table, criteria on another

• Easier to code than JOIN, but may be slow

• SELECT … FROM Names WHERE ID IN (SELECT CarID WHERE Color = ‘Red’)

• Can do instead with JOIN or a “correlated” sub-SELECT

Previous slide

Next slide

Back to first slide

View graphic version