How to write a query with Navision tables with SQL Server

Flashtn

Hi All,

I want to write a query using Query Anlyser of SQL Server 2000. I write the following "select [document No] from dbo.<Society_Name>$[Item Ledger Entry]". The system don't accept this syntax. There is any one who can help me ? Thank you in advance

kine

try

select [document No] from dbo.[<Society_Name>$Item Ledger Entry]

Flashtn

Thank you very much