Hi all,

I have 3 tables :

Mastertable
batchno

11111
22222
33333
44444

Detailtable:
Batchno Price product

11111 1000 01
22222 2000 02
11111 1500 03
22222 2500 04

TaxesTable :
Batchno Tax product

11111 10 01
11111 20 01
11111 30 03
11111 40 03
22222 10 02
22222 20 02
22222 30 04
22222 40 04

How to create a SQL command to get the result as :

batchno product price tax1 tax2 total(Price + Tax )
11111 01 1000 10 20 1030
11111 03 1500 30 40 1570

22222 02 2000 10 20 2030
22222 04 2500 30 40 2570

............................................
............................................

Tia