SELECT BANK ACCOUNT.*FROM BANK ACCOUNT ORDER BY ACCOUNT NAME
What is the missing operator here? In sql statement, pls I need help
What database are you using?
Does Bank Account really have spaces in? Also does Account Name really have spaces in?
YES IT HAVE SIR
Spaces in these names are problematic and there are different ways of dealing with it:
Try putting  around the words with spaces in
IT DOES HAVE SPACES SIR
STILL NOT WORKING SIR
Do you get an error message?
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