sql question

[Neresaos]

Hi, I have a program called shopassist that permit me make sql sentences. I need to get next fields: description and cost price from Invntry.DB so I did the next:

select description, cost price from Invntry.DB

but It doesn't worked, I've tried the next:

select description, [cost price] from Invntry.DB

select description, 'cost price' from Invntry.DB

select description, "cost price" from Invntry.DB

but nothing. someone knows what can I do?. Thankyou!!

[MAK]

Are you sure [Inventory.DB] is a table in msaccess? Access will not allow such naming convention.


try this

select description, [cost price] from Invntry


If it is not ms-access then try this


select description, [cost price] from [Invntry.db]