hey guys

I need something similar:
first and foremost, i need all the info about evry customeri have, and then
a count of how may order then have for me. (never got it working)
im guessing something like this

select *,count(*) as orders from C,O group by O.domain having orders>-1

however, this gives me a really strange result:
all the info from both tables, with both (only 2 at the moment) orders in 2
rows
and the same customers info in both of them

what would be the best way to make 15 queryes become 1 big query?

List = "Select * from C";
(gets 14 customers)
do until Liste.EOF (basicly C!ASP)
Orders = "select Count(*) as orders from O where domain=' List("domain") '
";

Regards,

Doc

> >
> > Incredibly difficult.
> >
> > select foo,count(*) as cnt from da_table group by foo having cnt >1;
> >
>
> ahh, I'd be slapping my forehead right now, except I've never used
"having"
>
> Thanks for helping out. :)
>
> Stephen




---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to