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