That is the problem... it complains about that structure unless I
insert a loj for any table at all before linking the procedures up.
To: Multiple recipients of list delphi
<[EMAIL PROTECTED]>
Send reply to: [EMAIL PROTECTED]
From: "Nello Sestini" <[EMAIL PROTECTED]>
Subject: Re: [DUG]: SQL foolishness
Date sent: Thu, 12 Jun 2003 17:45:14 +0700
> Rohit
>
> in the form without the loj, presumably you want
> the result set to be rows from cln matched with
> rows from the return of Get_Address where the
> Ref_Numbers match. (right?)
>
> So why isn't the query like this:
>
> select count (cln."Ref_Number") from
> "Client_Main" cln
> , "Get_Address" ('PST','C',cln."Ref_Number") adr
> where cln."Status" = 'A'
> and cln.Ref_Number = adr.Ref_Number
> order by cln."First_Name"
>
> (i'm assuming Get_Address returns a row with a column
> for Ref_Number)
>
> I rarely use this method of combining rows (i use joins)
> but when i do the "where" always links them in the same
> way a join would.
>
> does this make any sense?
>
>
> -ns
> http://www.roserox.co.th
>
>
> ---------------------------------------------------------------------------
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
> To UnSub, send email to: [EMAIL PROTECTED]
> with body of "unsubscribe delphi"
> Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
>
Regards
Rohit
====================================================
==================
CFL - Computer Fanatics Ltd. 21 Barry's Point Road, AKL, New
Zealand
PH (649) 489-2280
FX (649) 489-2290
email [EMAIL PROTECTED] or [EMAIL PROTECTED]
====================================================
==================
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
