Index

J

JOIN keyword, 169

Access, 389

INNER JOIN, 171

Oracle, 170

OUTER JOIN, 180

subqueries, 151

joining strings

see concatenating strings.

joins, 167

additional Oracle joins, 190

Cartesian product, 167

cross joins, 169

equi-joins, 169, 172

full outer joins, 184

inner joins, 171, 178

left outer joins, 181

multiple tables, 172

natural joins, 190

nested joins, 174

non-equi joins, 175

outer joins, 180

right outer joins, 183

self-joins, 419

simple joins, 167

junction tables

many-to-many relationship, 24

ProductCatalog database, 393

role-based security, 458

creating stored procedures, 492

RolePermission table, 469

UserRoles table, 466