Hi Agung

At 01:50 pm 08/12/2004, you wrote:

>SELECT (select BOSDRAMT from OSAcctDrAmt(s.bDrAmt, uf.bDr, uf.bCr)) AS bBalDr
> FROM tAccountsJV t
> JOIN sAccountsJV s
> ON s.iPID = t.iID
> AND s.iAcctID = 485
> LEFT JOIN uOSAccounts uf
> ON uf.iPID = t.iID
> OR uf.iSID = t.iID ;
>:), i am not testing this procedure before, but i do with my own procedur
>and it's work fine.

Thanks a lot for responding. That's the way it worked. I am pretty much a
newbie for SQL.




Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://ahmedabad.sancharnet.in/vso_ad1/
namitbn@...
___________________________________________


----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.807 / Virus Database: 549 - Release Date: 07/12/2004


[Non-text portions of this message have been removed]