Hello SQL Gurus
I am trying to write an sql statement that will return a row which contains
vendor info, how much he owes, total payments and balance due.
The results should look like this :
ABC,VENDOR ONE,333.33,199.98,133.35
DEF,VENDOR TWO,333.33, 0.00,333.33
The statement uses 3 tables and
---
> -Original Message-
> From: DL Neil [mailto:[EMAIL PROTECTED]]
> Sent: 05 February 2002 17:58
> To: Peter Lovatt; [EMAIL PROTECTED]
> Subject: Re: Sql gurus
>
>
> Hi Peter,
>
> > I am working on a search logging script to count the most
> popu
Hi Peter,
> I am working on a search logging script to count the most popular word or
> phrases searched for.
>
> Table
>
> I could add a line for each search, and aggregate the results for reports,
> but I was wondering about the following which would keep table sizes down.
>
> | search word
Hi
I am working on a search logging script to count the most popular word or
phrases searched for.
Table
I could add a line for each search, and aggregate the results for reports,
but I was wondering about the following which would keep table sizes down.
| search word | count |
=