Joining SQL tables.

Hi All,

I need this portion of SQL urgently. How do i link ORDR and OPKL tables together? i want to call our my SO with the status release (R). But the release date would be from OPKL table <--'PickDate' . How do i join this? Basically i want to join the PickDate with my SO released.

Appreciate your advice.

Thanks,

Harith