How we can Concatenate two column data in one
Hi All i need your help, I have a requirement like from two diffrent table we have saparate column and i want to club both colum data in one and want to display in dropodwn example : table 1 table 2 Column name : Hospital Name Column name : Service Value : Apollo Value : Cardio : GB Panth Gayno
Hi All i need your help, I have a requirement like from two diffrent table we have saparate column and i want to club both colum data in one and want to display in dropodwn example : table 1 table 2 Column name : Hospital Name Column name : Service Value : Apollo Value : Cardio : GB Panth Gayno : Apple Ortho Pedia ENT requirement is hospital might have multiple services so ,on every hospital name I want to club the service and want to display in dropdown like Apollo - Cardio GB Panth - Cardio Apple - Ortho please help me for the same thanks in advance