You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Example : output to identify columns is not correct for below query
SELECT
Calendar_year_lookup.Yr,
{fn concat('Q',Calendar_year_lookup.Qtr)},
Outlet_Lookup.State,
Article_lookup.Family_name,
sum(Shop_facts.Amount_sold),
sum(Shop_facts.Quantity_sold),
sum(Shop_facts.Margin)
FROM
Calendar_year_lookup,
Outlet_Lookup,
Article_lookup,
Shop_facts
WHERE
( Outlet_Lookup.Shop_id=Shop_facts.Shop_id )
AND ( Article_lookup.Article_id=Shop_facts.Article_id )
AND ( Shop_facts.Week_id=Calendar_year_lookup.Week_id )
GROUP BY
Calendar_year_lookup.Yr,
{fn concat('Q',Calendar_year_lookup.Qtr)},
Outlet_Lookup.State,
Article_lookup.Family_name
The text was updated successfully, but these errors were encountered:
Example : output to identify columns is not correct for below query
SELECT
Calendar_year_lookup.Yr,
{fn concat('Q',Calendar_year_lookup.Qtr)},
Outlet_Lookup.State,
Article_lookup.Family_name,
sum(Shop_facts.Amount_sold),
sum(Shop_facts.Quantity_sold),
sum(Shop_facts.Margin)
FROM
Calendar_year_lookup,
Outlet_Lookup,
Article_lookup,
Shop_facts
WHERE
( Outlet_Lookup.Shop_id=Shop_facts.Shop_id )
AND ( Article_lookup.Article_id=Shop_facts.Article_id )
AND ( Shop_facts.Week_id=Calendar_year_lookup.Week_id )
GROUP BY
Calendar_year_lookup.Yr,
{fn concat('Q',Calendar_year_lookup.Qtr)},
Outlet_Lookup.State,
Article_lookup.Family_name
The text was updated successfully, but these errors were encountered: