SELECT BANK ACCOUNT.*FROM BANK ACCOUNT ORDER BY ACCOUNT NAME
What is the missing operator here? In sql statement, pls I need help
Liwons
0
Newbie Poster
Recommended Answers
Jump to PostWhat database are you using?
Does Bank Account really have spaces in? Also does Account Name really have spaces in?
Jump to PostSpaces 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 PostTry putting [] around the words with spaces in
All 9 Replies
DaveAmour
160
Mmmmmm beer
Featured Poster
What database are you using?
Does Bank Account really have spaces in? Also does Account Name really have spaces in?
Liwons
0
Newbie Poster
YES IT HAVE SIR
Minimalist
96
Posting Pro
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
DaveAmour
160
Mmmmmm beer
Featured Poster
Try putting [] around the words with spaces in
Liwons
0
Newbie Poster
IT DOES HAVE SPACES SIR
Liwons
0
Newbie Poster
STILL NOT WORKING SIR
DaveAmour
160
Mmmmmm beer
Featured Poster
Do you get an error message?
Reverend Jim
4,780
Hi, I'm Jim, one of DaniWeb's moderators.
Moderator
Featured Poster
Try
SELECT * FROM [BANK ACCOUNT] ORDER BY [ACCOUNT NAME]
but if possible you should rename the columns by replacing the spaces with underscores.
Liwons
0
Newbie Poster
THANK YOU SIR FOR HELPING ME IT WORKS :D
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.