Relative Content

Tag Archive for sqlsql-server

Query with joins to build product with options

I have created the below select query that joins 5 SQL tables. The modifier table either uses the NAME column to display the modifier name or the ITEM_RECORD_KEY column to reference the RECORD_KEY of the ITEM row from the ITEM table to display the Modifier name.