Jasmine Sandlas
asked on
How to write a SQL statement to have this scenario concluded | URGENT | IMPORTANT | PLEASE HELP
How to write a SQL statement to have this scenario concluded :-
IF A_NO = B_SERIAL_NO THEN A_NO + '-' + RIGHT(B_SERIAL_NO,4) ELSE A_NO + '-' + B_SERIAL_NO --> populate to some Y in different table
Please help experts.
A_NO and B_SERIAL_NO are from the same table X
IF A_NO = B_SERIAL_NO THEN A_NO + '-' + RIGHT(B_SERIAL_NO,4) ELSE A_NO + '-' + B_SERIAL_NO --> populate to some Y in different table
Please help experts.
A_NO and B_SERIAL_NO are from the same table X
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER