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

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

Recommended Answers

What database are you using?

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

Jump to Post

Spaces in these names are problematic and there are different ways of dealing with it:
http://stackoverflow.com/questions/14190798/how-to-select-a-column-name-with-space-between-in-mysql-on-liunx-ubuntu

Jump to Post

Try putting [] around the words with spaces in

Jump to Post

All 9 Replies

What database are you using?

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

YES IT HAVE SIR

Try putting [] around the words with spaces in

IT DOES HAVE SPACES SIR

STILL NOT WORKING SIR

Do you get an error message?

Try

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

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

THANK YOU SIR FOR HELPING ME IT WORKS :D

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.