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
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,968 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.