How to join wks_workspace & p_project?

waikong

I am trying to generate a query to link the workspace and project

do anyone have any idea how can I do that?

workspace table: wks_workspace
project table: p_project

what is the relationship?
wks_workspace <---- ??? ----> p_project

WorkSite MP 4.1.1 running on Windows Server 2003

thank you!

dbguy

DOC_DOCUMENT is the "glue" it has a WORKSPACE_RSID column that refers to WKS_WORKSPACE.SID and P_PROJECT.P_SID refers to DOC_DOCUMENT.SID.