Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Spaces in Table Names
I have a table named 'Order Details' that cannot be renamed. When I try to work with it, I get syntax errors I'm assuming are related to the space in the table name. I've tried all combinations of quotes to fix this issue but to no avail. ex "Order Details.name" 'Order Details.name'... -
resultset data question
I'm working on a query and I need it to return 2 versions of the same column, so I'm trying to nest the 2nd version in to the first to return the results. Here are my queries: select modifications.timestamp, clients.name, remote_sites.name, modifications.name, oiversions.name from...
