Using Joins

• You must specify the join condition

  • Can be specified in the WHERE clause

SELECT doc.title, dt.doc_type

FROM documents doc, doctype dt

WHERE doc.doc_type_id = dt.type_id

• Can be spcified in the FROM clause(ANSISQL Standard)

SELECT doc.title, dt.doc_type

FROM documents doc JOIN doctype dt

ON (doc.doc_type_id = dt.type_id)

• JOIN sytax is similar in most databases but can vary

Copyright © 1997-2024, Maryland Cold Fusion User Group. All rights reserved.