lusercfc Posted March 4, 2015 Share Posted March 4, 2015 This is TimesTen which I'm not really familiar with but it's a flavour of SQL... Think of column_two as a userID and column_three as services they have purchased... so one user may have purchased many items. What I need to do is find all the users who have purchased services 3 *and* 12... if they've also purchased more (68, 76 etc) thats OK but I need to exclude them if they've purchased 3 *or* 12 (but not both) Here's how I can list all the services (column_three) they have purchased Command> SELECT * FROM table WHERE column_two = 299993025; < 234563210, 299993025, 3, N > < 247146769, 299993025, 12, Y > < 261197904, 299993025, 68, N > < 266960384, 299993025, 76, Y > < 265304246, 299993025, 84, N > < 248300956, 299993025, 87, Y > < 231784018, 299993025, 88, Y > < 201720976, 299993025, 90, Y > 8 rows found. I modified the query as follows but it doesn't find anything. Command> SELECT * FROM table WHERE column_2 = 299993025 AND (column_3 = 3 AND column_3 = 12); 0 rows found. For what it's worth, just having one column_3 item queried does work Command> SELECT * FROM table WHERE column_2 = 299993025 AND (column_3 = 3); < 234563210, 299993025, 3, N > What am I missing? Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.