Liveware Publishing Support Forum

What^s the best way to do multiple scan reports with SQL?____I read this technote:____http://www.livewarepub.com/ftp/TechDocs/Multi-Scans_in_SQL.PDF____It involves setting up a complicated union of two SQL queries. It seems like an awful lot of work for something that was so simple with Dbase files and R&R5. As it is, I^m not sure it^s even usable for a normal user.____Is there a better way?____Tom

Create a SQL report, export data to DBF and then use the Xbase edition to create a multiple scan is the only other alternative to the problem.______Kathleen__R&R Support