SQL Promt will not work on table named "Item"
If I type:
select * from Item where Item.
it will not list any of the fields that belong to te table named Item.
In fact, when I type the period symbol it will translate "Item." into "ITEMINFO." that is another table in the database.
The table named Item is used in many relations in our database so this is very annoying.
Can it be that SQL Promt think that "Item" is a reserved keyword?