Subject RE: ORDER OF TABLE From Mustansir Ghor <mustan31@hotmail.com> Date Thu, 21 Mar 2019 14:55:44 -0400 Newsgroups dbase.getting-started Attachment(s) Capture2.PNG, Capture3.PNG Dear All I have an SQL statement with single table as follows. Its browse is attached as Capture2. select * from pharmrec I have same table opened with a join statement in order to relate item name as follows. Its browse is attached as Capture3 select * from pharmrec a join pharm p on a.item=p.code My problem is I need to use join table in order to generate my report. But order of records in a single table that were entered in the grid are changed in the join table although order by clause were not used. So how to use the join table and yet report to generate same order of records as were entered in the grid. Can anybody help me on this. In dbaseIV we called it natural order. Best Regards Mustansir