Re: Abandoned Cart Query

2002-04-05 Thread Scott Gifford
rory oconnor <[EMAIL PROTECTED]> writes: [...] > each item in a cart is a record, so simply querying on records won't > work. What I need to count is how many distinct customerId's there > are. a sample from the table looks like: > > cartItemIdcustomerId productId > 1944 244

Abandoned Cart Query

2002-04-05 Thread rory oconnor
I'm trying to write a query that will tell me how many abandoned carts there are in a "cart" table I have. each item in a cart is a record, so simply querying on records won't work. What I need to count is how many distinct customerId's there are. a sample from the table looks like: cartItemId