The SitePoint Forums have moved.

You can now find them here.
This forum is now closed to new posts, but you can browse existing content.
You can find out more information about the move and how to open a new account (if necessary) here.
If you get stuck you can get support by emailing forums@sitepoint.com

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

I need a single query (without using a subquery) that will give the the amount of Numbers that sent SUBSCRIBE STOP the same day they sent SUBSCRIBE START for a particular day.

So for this example it would produce 1 for 2004-12-01 and 2 for 2004-12-02.

Then I need a sinle query (without using a subquery) that will give the amount of Numbers that haven't sent a SUBSCRIBE STOP since they sent SUBSCRIBE START on a particular day.

So for this examle it would produce 2 for 2004-12-01.

I hope I explained that ok If I could use a subquery then it would be simple but I can't. But I've read you can use join's to replace subquerys. Unfortunatley my knowledge of join's isn't that extensive