Hello, I am trying to create a query that has, I believe it's called, alias field names.
Example: Select fldValue1 as fldThisNewFieldName Where fldValue1 > 1 Into tblNewTableName Just so I'm clear, the result of the query would be a new table named tblNewTableName with one field called fldThisNewFieldName with all the values being greater than 1. MapInfo gives me an error that says: Variable or Field Not Defined. Found [fldThisNewFieldName] while searching for [from]. This has me absolutely stumped. I've searched every archive I could and could not find a resolution to what I'm doing wrong. Could you please forward your response to the e-mail address below? Thank you very much for taking the time to look at this. Marty Sprenz (RF Engineer - Contractor) 100 Concourse Pkwy Birmingham, AL 35244 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Office: 205-444-3572 Mobile: 404-509-9820
