Hi, I have data that resembles the following: Request Number Description REQ0090887 TASK0236753 Foo REQ0090887 TASK0234920 Bar REQ0090887 TASK0234921 Bar REQ0090887 TASK0237261 Foo REQ0086880 TASK0224045 Foo REQ0086903 TASK0224555 Bar REQ0086990 TASK0223977 Bar REQ0087061 TASK0226748 Foo REQ0087061 TASK0223810 Bar
I want to group request values where each request contains both a task with description Foo and Bar. So in the above example, only REQ0090887 and REQ0087061 meet this. I would be grateful for any guidance on how to write this. Thanks, jlc _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users