transfer data from one database to another data base

See more:

SQL

Hai.. i have three table with different database i need move data TableName2 based on Branch to tablename3 , each ItmsGrpCod(TableName3 )to transfer the(FrmDate ToDate Percent)Please any one give me idea...
TableName1(parenttable )Databasename1

DocEntry	Branch	FrmDate	ToDate
1	01	2013-04-12	2013-04-16
2	01	2013-04-12	2013-04-16
3	01	2013-04-12	2013-04-16
4	01	2013-04-12	2013-04-16
5	03	2013-04-12	2013-04-16
6	02	2013-04-12	2013-04-16

TableName2 Databasename1

DocEntry 	FrmDate	         ToDate 	Percent
1		12/04/2013	16/04/2013	10
2		12/04/2013	16/04/2013	9
3		12/04/2013	16/04/2013	10
4		12/04/2013	16/04/2013	12
5		12/04/2013	16/04/2013	10

TableName3 Databasename3

ItmsGrpCod,ItmsGrpNam
100	Items
101	Accessories
102	HP Printers
103	IBM Printers
104	PCs
105	Servers

i need out put like this based on Branch id(TableName1 Databasename1)

DocEntry GrpCode FrmSlab	ToSlab	Percent
1	100	12/04/2013	12/04/2013	10
2	101	12/04/2013	12/04/2013	9
3	102	12/04/2013	12/04/2013	10
4	103	12/04/2013	12/04/2013	12
5	104	12/04/2013	12/04/2013	10
	105	12/04/2013	12/04/2013	12