home Links Articles Books Past Meetings Photos SiteMap
The MDCFUG is sponsored by TeraTech. Visit us at www.TeraTech.com

Please send
comments/questions to


Using Joins

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

Previous slide Next slide Back to first slide View graphic version

Home | Links | Articles | Past Meetings | Meeting Photos | Site Map
About MDCFUG | Join | Mailing List |Forums | Directions |Suggestions | Quotes | Newbie Tips

Copyright © 1997-2018, Maryland Cold Fusion User Group. All rights reserved.
< >