Hi all, Is it possible to use LEFT JOIN (or RIGHT JOIN) when querying queries? I get two queries from cfstoredproc (two differenent data sources) and then use querying queries to combine them. But it seems like i can not use LEFT JOIN. I always get an error like this:
unknown exception condition PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag I even tried to use *=. It gave me an invalid sql error. Anyone knows how to solve this? Thanks JL ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
