In my Database, there is a table called PackageLocationXref Old
When I write this query
SELECT COUNT(DISTINCT LocationID)
FROM PackageLocationXref Old
The result showing invalid. It is because there is a space in the database table name. Is there any way to solve it.
Screenshot attached
Hi @shaonyuvi
Refer to your database documentation on how it requires quoting on identifiers like tables.
Try with double quotes "some table"
Find the database designer. Beat him/her to a pulp!
Double quotes not working here. How to make it work?
@shaonyuvi
Post "Diagnostic Info" from Admin > Troubleshooting.
Post which database type you are querying.