Inner Join

Hi experts,

Please let me know inner join for following two queries, i am not able to write , it's giving error. Points will be given for sure.

1) Select customer menu’s associated with the retroactive pricing condition record

Select VBAP.VBELN (Contract #)

VBAP.POSNR (Item #)

Where KONV.KNUMH = KONH.KNUMH (Condition record number)

VBAK.KNUMV = KONV.KNUMV (Document condition number)

VBAK.AUART = “ZMNU” (Document Type)

VBAP.POSNR = KONV.KPOSN (Item #)

2) Select all customer menu and item combinations that are associated with each customer pricing contact that have an associated output condition record in table – B504 (Customer Pricing Contact – PARNR)

Select B504.PARNR (Contact #)

VBPA.VBELN (Contract #),

VBPA.POSNR (Item #)

Where VBPA.PARNR = B504.PARNR (Contact #)

VBPA.PARVW = “Z8”

VBAK.AUART = “ZMNU”

Inner Join VBAK.VBELN = VBPA.VBELN