Does anyone know the JOIN statement in SQL that is used to relate the item and itemclass tables in RMS? I cannot seem to figure it out.
Thanks,
nick
Join Statement
Nov 30, 2005
2 Replies
They don't directly relate. Take a look at the ItemClassComponent table, this is where they get related to the Item table.
Item LEFT JOIN ItemClassComponent With(NOLOCK) ON Item.ID ItemClassComponent.ItemID LEFT JOIN ItemClass With(NOLOCK) on ItemClassComponent.ItemClassID ItemClass.ID
Rob
"Nick" wrote:
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required