Blue
White
Purple
Green
Red
Orange
Blue Light
White Light
Purple Light
Green Light
Red Light
Orange Light
Dear all, can someone help me to fix a sql selec question, example:id bank code1 A_bank 1112 B_bank 2223 B1_bank 3334 C_bank 4445 C1_Bank 555how can i quarry one or more bank_name to get the result as below search result:3 B1_bank 3334 C_bank 444ThanksNet//
Select id, bank, code from [database] where code="333" or code="444"
What are you exactly trying to query? I can give ya some help I just need more details..But I will help.
Select id + ' ' + bank + ' ' + code from [database]this will print out . id bank codewith spaces between.