But you would do it this way... count(tablename.*)
-Novak
-----Original Message-----
From: Mickael [mailto:[EMAIL PROTECTED]
Sent: Monday, December 01, 2003 10:18 AM
To: CF-Talk
Subject: Re: SQL Help on Join
how do I specify the tablename with the Count(*)?
----- Original Message -----
From: Scott Weikert
To: CF-Talk
Sent: Monday, December 01, 2003 1:37 PM
Subject: Re: SQL Help on Join
Mickael writes:
> Select Count(*) as TotalAccounts, Sum(Orig_amt) as SumOrig_AMT,
Sum(Cur_Bal) as SumCurBal, Sum(Pmt_amt) as SUMPmtamt
> from Client_debt
> Left outer join Client_pmt on client_debt.debt_id =
client_pmt.debt_id
You're specifying the table names of the fields in your JOIN but not
in your
SELECT. Should be, for example, SUM(tablename.Orig_atm), etc.
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
