So, it looks like you can't do a statement like this:IF SELECT * INTO #TempELSE SELECT * INTO #Temp WHERE ... Well, if you happen to be using Sql Server you can do that sort of thing in T-Sql.

In this sample statement, the condition (table1.keyfield=table2.keyfield) tells SQL to find records in both tables that contain matching values in the column named by keyfield.

While checking SQL syntax itself is somewhat straightforward, [Joe]’s sql-lint tool will also check the semantics of it by looking up the actual database and performing sanity checks on it.

You can enter several non-SELECT SQL statements at one time, separated by semicolons. Do not end the final statement with a semicolon. Note: Using more than one statement and semicolons applies only ...