Learn to master the SQL command line with this crash course in JOIN syntax. In response to previous SQL lessons, TechRepublic members including Michael M. and Jason P. have posted comments ...

So, it looks like you can't do a statement like this:<BR><BR>IF <BR> SELECT *<BR> INTO #Temp<BR>ELSE<BR> SELECT *<BR> INTO #Temp<BR> WHERE....<BR><BR>What the best way to work around this?

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...