selection from 3 tables

Hi,

I have select-options: s_matnr for mchb-matnr &

s_pradh for mara-pradh & s_wdatu for lqua-wdatu.

I want to select records from mchb(matnr,wekrs,lgort)

, mara(matnr,pradh) and lqua(matnr,wdatu)

can any one tell me how do i achieve this?

points guaranteed..

cheers

kaki