Last post May 15, 2018 04:32 PM by Lannie
May 15, 2018 03:13 PM|Rakib1|LINK
Trying to get the below result in query using group by from below 3 tables. if you notice there are two items in table 1. one item with color one another black. i thing we may use max(), min() function.
May 15, 2018 04:32 PM|Lannie|LINK
Does Table 2 already include the values for ITEM_INSPECTED > 2??
You have comma separated values in table 3 that you normalize into table 2, but then you create new values like parapet in table 2 and use in table 1.
The design appears not relational database traditional design.