ok... authorizations and charges...  two tables..

Card Number 1 gets authorized 20 times for use (20 rows in the
authorizations table) and when the transaction is completed they get charged
20 times (20 rows in the charges table) .. however we've been finding that
authorizations are not always ending in charges.  (Essentially people are
cheating the system) and I need to find out who.  Card numbers are the
same... I ran this without the num1=num2 and it gave me very bad results.. I
think my counts are off base.  num1 and num2 were the same for all of them.
I know this isn't the case.

so...

 SELECT authtable.cardnumber, count(authtable.cardnumber) as num1,
count(chargetable.cardnumber) as num2 FROM authtable, chargetable WHERE
authtable.cardnumber = chargetable.cardnumber AND num1 != num2

is what I'm shooting for logically.. once again.. I think the counts are
messed up... (I might be completely off base here..)

Thanx,

-Jonathan





----- Original Message -----
From: "Rick Emery" <[EMAIL PROTECTED]>
To: "'Jonathan Underfoot'" <[EMAIL PROTECTED]>; "[PHP-DB]"
<[EMAIL PROTECTED]>
Sent: Tuesday, February 19, 2002 4:06 PM
Subject: RE: [PHP-DB] SQL


> How could you possibly have such a condition exist?  That is, what
relation
> do the counts have to the contents of the name field?
>
> What ARE you trying to really accomplish?
>
> -----Original Message-----
> From: Jonathan Underfoot [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 19, 2002 2:57 PM
> To: [PHP-DB]
> Subject: [PHP-DB] SQL
>
>
> Is it possible to do a comparison of values from a count...
>
> for example...
>
> SELECT table1.name, count(table1.name) as num1, count(table2.name) as num2
> FROM table1, table2 WHERE table1.name = table2.name AND num1 = num2
>
> This sort of thing dosent work for me.  How do I reffrence a count later
in
> the where clause?
>
> Thanx
>
> -Jonathan
>
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to