S
Support
Hi,
I have 3 tables:
orders 65k records
orderlines 130k records
userswithorders 45k records
I have run a query to find users who have ordered from dept footwear/
menswear and womenswear. Under the footwear dept, there is a subdept called
youthfootwear so I have excluded this by running one query that(briefly):
query dept for having criteria like *wear
query subdept for having criteria not like youth*
I have put a count on the users returned so that only 1 record per user
This returns 29909 records
I have then run another query to get all other orders except for youth
footwear:
query dept for having criteria not like *wear
query subdept for having criteria not like youth*
This returns 45500 records
I then ran a query for just youth footwear and that came back at only 1000
odd records.
Do these results look right?
Also, is it possible to run a NOT query on more than one criteria? EG I
would want to query criteria for NOT having *wear NOR belts?
Many thanks
I have 3 tables:
orders 65k records
orderlines 130k records
userswithorders 45k records
I have run a query to find users who have ordered from dept footwear/
menswear and womenswear. Under the footwear dept, there is a subdept called
youthfootwear so I have excluded this by running one query that(briefly):
query dept for having criteria like *wear
query subdept for having criteria not like youth*
I have put a count on the users returned so that only 1 record per user
This returns 29909 records
I have then run another query to get all other orders except for youth
footwear:
query dept for having criteria not like *wear
query subdept for having criteria not like youth*
This returns 45500 records
I then ran a query for just youth footwear and that came back at only 1000
odd records.
Do these results look right?
Also, is it possible to run a NOT query on more than one criteria? EG I
would want to query criteria for NOT having *wear NOR belts?
Many thanks