hi, i have a column which are having values r00,r11 like that and another column having a range a00-a09 so i want third column in which i can show that in front of roo or r11,third column shows the range like a00-a01 of r00 or r11
1. CREATE TABLE statement(s) to create test tables for your query 2. INSERT INTO statement(s) to populate the test tables in step 1 3. Your query so far against the tables created in step 1 an step 2 4. The required results from the finished query.