Hi Paul,

There's a problem with your TaxesTable design. It niether has a primary key nor it has a conbination of fields that can be used as a primary key.


>
>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