SQL Server Query

You can use INNER JOIN for your query.

like this.

SELECT t1.field1, t1.field2, t2.field1, t2.field2 FROM table1 AS t1 INNERJOIN table2 AS t2 ON ( t1.field1 = t2.field1 );

in which you should have one common fild in both table.

or You can use below one also.

SELECT s.driverid, d.name, s.driverMobileno, s.responses
FROM sendsms AS s, driver AS d
WHERE s.driverid = d.driverid
;

it will give field from both table.