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 654warm regards,