If you have access to the actual Access database, you can build a query in
Access' query builder, then use the sql view to copy and paste the sql code
into your cold fusion template. THis is the coward's way out of actually
learning the sql, but it's worked for me in the past when I've tried to
write sql that's a little above my head. This allows you to test the query
results right away, to make sure you're getting the results that you want.
If you're unsure how to change joins within Access' query builder, contact
me off list.
Chris
----------------------------------------------------------------------------
--
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
