Guest User

Untitled

a guest
Aug 16th, 2018
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. SQL Query Syntax Error - Spaces in Field Names
  2. SELECT * FROM 'OV2 BAS' AS bas
  3. INNER JOIN 'OV2 RefID' AS ids ON 'bas.Ref ID' = 'ids.Ref ID'
  4. WHERE ids.ENUM_H = 'TDischarge';
  5.  
  6. SELECT * FROM [OV2 BAS] AS bas INNER JOIN [OV2 RefID] AS ids ON bas.[Ref ID] = ids.[Ref ID] WHERE ids.ENUM_H = 'TDischarge';
  7.  
  8. SELECT * FROM [OV2 BAS] AS bas
  9. INNER JOIN [OV2 RefID] AS ids ON bas.[Ref ID] = ids.[Ref ID]
  10. WHERE ids.ENUM_H = 'TDischarge';
  11.  
  12. SELECT *
  13. FROM [OV2 BAS] AS bas
  14. ^^^^^^^^^
Add Comment
Please, Sign In to add comment