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/
