Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Double filtering.

 
Jacky Luk
Ranch Hand
Posts: 634
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

I tried to filter the normal customer 1st, then the customer created in this month
The first subquery returns no sets.
I seem to be having trouble when the order details table has got nothing in it

update:

By further breakdown of the problem, how can this return something
when order details has nothing inside, thus a 0 NetSales

update2:
I solved it by adding another union, making the no sales customer in the normal's set
, while having the VIP unchanged


Thanks
Jack
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic