> Thanks for trying to help me out. Actually, I am already
> aware of the query builder in MS Access. But I would like
> to build my queries dynamically and I have quite a few
> tables involved, so it would be much easier if I could do
> the Left and Right joins in my WHERE statement rather than
> in the FROM statement.
It seems to me that it would be just as easy to build dynamic queries using
LEFT OUTER JOIN or RIGHT OUTER JOIN. You'd still need some conditional logic
around a single line of SQL code. If you can give me a sample dynamic query
using WHERE joins, I can try to convert it for you.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
