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
Kellylee22Asked:
Who is Participating?
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.