> An inner join is reasonably similar to using pk=fk > in a where clause.
That statement deserves a little clarification. Both of these queries use inner joins: SELECT t1.*, t2.* FROM t1, t2 WHERE t1.pk = t2.fk SELECT t1.*, t2.* FROM t1 INNER JOIN t2 ON t1.pk = t2.fk The difference is that the second query uses the ANSI syntax for its inner join, while the first doesn't. Specific database engines may conceivably perform differently when analyzing each query, or may only support one syntax or the other, but they're still both inner joins. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4