SELECT * ; FROM mytable ; WHERE <some conditions> ; INTO CURSOR mycursorJust don't use alias in the fields references in report. There's also Query Designer in VFP. You can call it from VFP menu or from command window
Modify Query myqueryIf query with name 'myquery' doesn't exist it'll be created.