Select query from transaction table

For some reason I can't run a select query on the transaction table. Other tables work fine eg. select * from transaction returns Incorrect syntax near the keyword 'transaction'

Any ideas?

Cheers

Reply to
jetspeed
Loading thread data ...

The rms database was originally designed in MS Access. It uses some SQL Server reserved words as table names. Transaction and Order spring to mind, but there may be a couple of others.

To query these tables you must delimit the tablenames: select * from [transaction]

Same thing anywhere that you use the transaction table such as the select list of joins. See the .qrp file for the Detailed Sales report for examples...

Glenn Adams Tiber Creek C> For some reason I can't run a select query on the transaction table. Other

Reply to
Glenn Adams [MVP - Retail Mgmt

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.