JAVA-SQL QUERY TO TO EXTRACT DATA FROM TWO TABLES : Select concat(substr(T_data,1,9),'001     ') AS Test_Data from DB1.T1 ;


Select * from DB1.T2 WHERE Test_Data  = 'Test_Data';


I need to join the DB1.T1 and DB1.T2 based on Test_Data