1. Home
  2. Point-Of-Sale Software
  3. Join Statement

Join Statement

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

Reply to
Nick
Loading thread data ...

They don't directly relate. Take a look at the ItemClassComponent table, this is where they get related to the Item table.

Reply to
Jason Hunt

Item LEFT JOIN ItemClassComponent With(NOLOCK) ON Item.ID ItemClassComponent.ItemID LEFT JOIN ItemClass With(NOLOCK) on ItemClassComponent.ItemClassID ItemClass.ID

Rob

"Nick" wrote:

Reply to
Rob

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.