hi, the structures and sample data contained in my 2 tables are given below table1 contains only one column. and only one value is present in this column at a given instance. table1 field_nm1 'tel_no' table2 tel_no, add_no, add_res, mob_no 2222 234 1.33 56 8761 321 5.67 22 A value in table1 is a column in table2. i need a sql query to access the values of this column(field_nm1) in table. something that functions like the below query. but the tel_no should not be used directly but must be fetched from table1 select tel_no from table2;