Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 234
  • Last Modified:

Dealing with A Table Column Called "FROM"

Hi ,

I am trying to run an OpenQuery in Sql Server 2008 that points to a Sql Anywhere database.  The problem is there is a column called "From".  I keep getting an error on this column and don't know how to work around this.  

SELECT * FROM OPENQUERY(Travel,
   'SELECT
      Ctrl,
      PostDate,
      CashAccount,
      AccountId,
                     From,
      CheckNumber,
      ReceiptNum,
      Amount,
      Applied,
      Branch,
      PrevBilled,
      Type,
      Remaining,
      InUseFlag,
      Status
      FROM DBA.Receipts')

Regards,

Kellylee
0
Kellylee22
Asked:
Kellylee22
1 Solution
 
wdosanjosCommented:
Try using either [From] or "From" instead.
0
 
Kellylee22Author Commented:
Thanks so much.  This worked.

Best Regards,

Kellylee
0
 
jorgedeoliveiraborgesCommented:
SELECT * FROM OPENQUERY(Travel,
   'SELECT
      Ctrl,
      PostDate,
      CashAccount,
      AccountId,
                    [From],
      CheckNumber,
      ReceiptNum,
      Amount,
      Applied,
      Branch,
      PrevBilled,
      Type,
      Remaining,
      InUseFlag,
      Status
      FROM DBA.Receipts')
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Tackle projects and never again get stuck behind a technical roadblock.
Join Now