Help with Complex SQL Query
Budget: $250 – $750 CAD
SQL Server OR LINQ
I have 3 tables:
Products (has Product.Id)
Fields (has Field.Name and Field.Id)
ProductFields (this has ProductId, FieldId, and FieldValue)
I need to generate a table with the Field.Name as the header, and the Field Value as the column.
* I will query multiple field names.
* I will query multiple products (so each row will be per product, with the columns being rows from ProductField table)
I have 3 tables:
Products (has Product.Id)
Fields (has Field.Name and Field.Id)
ProductFields (this has ProductId, FieldId, and FieldValue)
I need to generate a table with the Field.Name as the header, and the Field Value as the column.
* I will query multiple field names.
* I will query multiple products (so each row will be per product, with the columns being rows from ProductField table)