This kind of presentation changes are better be done in report, not in the SQL. It is relatively easy to do in SQL, but I don't recommend it.



>

>CREATE TABLE acmast (accode n(6), acname c(50),opamt n(10,2))
>SELECT acmast
>INSERT INTO acmast (accode,acname,opamt) VALUES (1, 'party name', 54200)
>
>CREATE TABLE sales (idno n(6), billno c(6), billdt d, accode n(6), qty n(7,2), amt n(10,2))
>INSERT INTO sales (idno, billno , billdt , accode , qty , amt ) ;
>VALUES (1, 'aa/101', DATE(2011,4,04),1,22,509)
>INSERT INTO sales (idno, billno , billdt , accode , qty , amt ) ;
>VALUES (1, 'aa/102', DATE(2011,4,14),1,28,852)
>INSERT INTO sales (idno, billno , billdt , accode , qty , amt ) ;
>VALUES (1, 'aa/103', DATE(2011,4,24),1,18,654)
>
>SELECT sales.billno,sales.billdt, sales.accode, acmast.acname, acmast.opamt, sales.qty, sales.amt ;
>FROM sales ;
>LEFT JOIN acmast ON sales.accode=acmast.accode INTO CURSOR tempcurs READWRITE 
>BROWSE 
>
>*** above code giving me result like 
>*-------------------------------------------------------------------------------
>* billno    billdt       accode       acname     opamt     qty      amt
>*-------------------------------------------------------------------------------
>* aa/101    04/04/2011    1           party name  54200     22      509
>* aa/101    14/04/2011    1           party name  54200     28      852
>* aa/101    24/04/2011    1           party name  54200     18      654
>
>*** but i need result like 
>*-------------------------------------------------------------------------------
>* billno    billdt       accode       acname     opamt     qty      amt
>*-------------------------------------------------------------------------------
>* aa/101    04/04/2011    1           party name  54200     22      509
>* aa/101    14/04/2011    1           party name            28      852
>* aa/101    24/04/2011    1           party name            18      654
>
>

>
>
>warm regards,
>mk.