how join works on 4 tables with same field

[kalwar]

i have 4 tables with common field voucherno in all
how can i match every table voucher with a one main table.

SELECT distinct voucher.voucherno,(opn.voucherfigure)as opn,(aakera.voucherfigure)as aakera FROM voucher INNER JOIN (opn INNER JOIN (aakera inner join (ring inner join forecast on forecast.voucherno=ring.voucherno) On ring.voucherno=aakera.voucherno) on aakera.voucherno=opn.voucherno ) ON voucher.voucherno=opn.voucherno

[mabbas110]

u do like join table 1 by 2 then 2 by 3 and then 3 by 4.

I think it will be okay.