> SELECT table1.*, table2.* > FROM table1, table2 > WHERE table1.category LIKE '%#category#%' > AND table2.category LIKE '%#category#%' > AND table2.Reviews <> #checkReviewCount#
arun, i think you may have a problem if you don't have a join condition for example, say table1 had 4 rows with dogs, and table2 had 3 rows with dogs, then the result will have 12 rows as a result of the join, and then the filter condition will be applied, which removes only those rows where table2's review count matches the review count parameter you pass in what columns should be used to join the tables? if it's category (sorry, i cannot really tell from what you've shown), then perhaps you *do* want 12 rows filtered! rudy - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "rudy" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
