Need to simple SQL statement for FoxPro 7.0 that will join certain data from to tables (onto a new table) based on certain criteria which are updated each month with new additional data. The SQL statement must be flexible so that it may be run each month with new montly data.
Fully functional and accruate SQL statement that works in FoxPro 7.0. Two tables will be emailed to coder so that he/she may code and test the SQL statement.
Windows 2000 and foxpro 7.0