select data from tables

Hi,

this is basic question but iam confusing.

in my selection contains two fields like matnr and werks.

if user give matnr only i will get all matnrs.

if user give matnr and werks i need matnr no's based on werks.

how can i write select statement based on mara and marc.

Regards,

Suresh.