Search results for query: *

Thanks a bunch. That made perfect sense. What I may do is a simple join to just find the ones that did return something and then run what you gave me and see who repurchased. The reason for this is sending Christmas cards to clients. And I don't want to send a Card to a jackass that bought...

I am trying to find out how many of my online purchasers ever bought anything and returned it and if they returned again and purchased something. So A buys B and returns B and then comes back and buys C and keeps it. I only want those that come back and buy junk from me. Heres what I have so...

I inherited my company and all that came with it including the database. I would love to be able to find what I have available to me. I have two tables: Contacts, Transactions within transactions I have Category1, category2, category3, etc.. Category1 is items, things like books, cake...

Never mentioned what I would like to have happen... :) I would like for the second query, the individual one to report purchase amount return amount purchase amount return amount purchase amount return amount instead of purchase null null null null...

I am running a query that finds all the clients that buy from me and return stuff within a certain range. In a range of 5 days it will give me 200 people. Now I want to see of them, who are the repeat offenders, so I wrote a new query for individual accounts. To do this I was using the MAX...

it runs but the actual query has 3000 lines of: c.sourceip between '4.2.145.0' and '4.2.145.63' OR c.sourceip between '4.2.170.64' and '4.2.170.127' OR and when it finishes it brings up IP's that are not between any of the IP's. My question then...Is my use of OR correct or no? The...

I thought I would impress my Father in Law by telling him I am a whiz at SQL. I'm alright but no whiz. These are IP's he wants to see if any of his clients are signing up from. He is diving into the world of CRM and I think he likes me more because I told him I could help. I figured or would...