Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

2
  • This is not quite what I asked for, probably due to my ambiguous question. But I worked from it and got what I wanted. So thank you very much! Commented Jun 7, 2013 at 3:16
  • One more question: I noticed that if I had duplicates in my table it would cross count each one multiple times and the result will be, if 8 duplicates for example, 64 rows. I guess this is because of the "cross join" or something not set in where clause. Is there a way to not select the ones that I have selected in previous rows in a query? Commented Jun 7, 2013 at 3:21