PERFORM A QUERY ON MORE THAN ON DATA FILE 1

[wilsong21]

PERFORM A QUERY ON MORE THAN ONE DATA FILE WITH THE SAME
DATA FIELDS IN ALL DATA FILES TO GET THE TOTAL RESULTS IN THE QUERY OF ALL DATA FILE COMBINED.

EXAMPLE OF MY CODE.

SELECT SHOENAME,SHOESIZE,COUNT(SHOENAME) FROM A1NSSRT.DBF,A2NSSRT.DBF,A3NSSRT.DBF GROUP BY SHOENAME

 

[bborissov]

Keep in mind that if you want ALL records to be selected you must use UNION ALL, becuase UNION ignores all duplicated records. Also Put all non agregated fields in GROUP BY clause.

Borislav Borissov

 

[wilsong21]

THANK FOR THE KNOWLEDGE IT WORKS PERFECTLY.