Im using visual foxpro9 and I have problem on my script to get minimum & maximum and to copy the data into another table using query command INTO TABLE. can help me to have complete commands for this.
your reply is most highly appreciate. Thanks
See my script and error displayed.
SELECT MIN(Journaldb.seq_num), MAX(Journaldb.seq_num),;
Journaldb.terminal, Journaldb.termi_name, Journaldb.type_,;
Journaldb.resp_code;
FROM journaldb;
WHERE Journaldb.type_ = "Cash ";
GROUP BY Journaldb.terminal;
ORDER BY Journaldb.terminal;
INTO TABLE jominmax.dbf
ERROR DISPLAYED in visual foxpro9 upon execute.
SQL: GROUP BY close is missing on invalid