0
SELECT BANK ACCOUNT.*FROM BANK ACCOUNT ORDER BY ACCOUNT NAME

What is the missing operator here? In sql statement, pls I need help

Edited by Reverend Jim: Please do not post in ALL CAPS

4
Contributors
9
Replies
19
Views
2 Years
Discussion Span
Last Post by Liwons
0

What database are you using?

Does Bank Account really have spaces in? Also does Account Name really have spaces in?

0

Try

SELECT * FROM [BANK ACCOUNT] ORDER BY [ACCOUNT NAME]

but if possible you should rename the columns by replacing the spaces with underscores.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.