how join works on 4 tables with same field
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
Re: how join works on 4 tables with same field
u do like join table 1 by 2 then 2 by 3 and then 3 by 4.
I think it will be okay.