>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 > >>