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