Sql problem

Hi
I"m using paradox and Local Sql.
One of my Tables fields is named : "From"
i saw that when i"m trying to make any sql query with this field i got an Error
Message.
can i make alias to field ?
how can i solve it ?
please short example ...
10x
Asi
i.i dont want to change the field name


asiAsked:
Who is Participating?
 
kretzschmarConnect With a Mentor Commented:
oops,
you meant a field

should go in the same manner,
just doublequote it

meikl
0
 
kretzschmarCommented:
hi asi,

try as follows

select * from "from"

meikl
0
 
StefaanCommented:
Hi,

You can create an alias like this :

SELECT
  MyTable.From AS MyAlias
FROM
  MyTable

Maybe you will have to use quotes like meikl mentioned, then it should look like :

SELECT
  MyTable."From" AS MyAlias
FROM
  MyTable

It is also possible that the AS keyword can be omitted.

Try it out and tell me what happens.

Best regards,


Stefaan
0
All Courses

From novice to tech pro — start learning today.