title: How can I add blank columns to the results of a SQL query?
body: <p>I'm working on a query that pulls demographic information for people who have visited a location. However, the fields required for this report aren't all available in the DB, and some will need to be added manually from a separate Excel file after I've exported the results of my query. The person who will be responsible for merging the two files asked if it would be possible to create blank columns so they can more easily see where the missing data needs to go, and I wasn't sure how to go about that. Obviously those blank columns could just be created in the exported spreadsheet, but I wondered if there was a way to add them in the SQL query itself.</p>
  <p>My <code>SELECT</code> statement currently looks something like this—I've just added comments to mark the missing fields so I can keep track of what order all the fields for this report need to be in.</p>
  <pre><code>SELECT DISTINCT
  PersonID,
  PersonFName,
  PersonLName,
  PersonDOB,
  VisitID,
  --StaffFName,
  --StaffLName,
  FacilityPhone,
  FacilityAddress,
  
  ...and so on
  </code></pre>
  <p>Since those two staff name fields don't exist in my DB, I obviously can't actually include them in the <code>SELECT</code> list. But is there a way to still include those two fields as blank columns in my query results? Something along the lines of &quot;<code>select [nothing] as StaffFName</code>&quot;?</p>