Hi all, i want to create a SQL query above 2 tablespaces. In the query i want to compare if the value i searched fore is in tsA or tsB.
I tryed it with something like this: SELECT * FROM tableA, tableB WHERE tableA.ts IN (#preserveSingleQuotes(myDocumentsA)#) OR tableB.ts IN (#preserveSingleQuotes(myDocumentsA)#) So, i want to check if the value is in A or in B. But the result is all entrys from tableA. How must i change the SQL query? Thank you in advance & with best regards nic. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290752 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
