Hello All -
I am new to SQL joins and I am having a difficulty grabbing data from another table.
The table I am primarily running select statements on to output the information I need is HRO. I am wanting to grab some data from the StoreInfo table, but, I cannot seem to get the INNER JOIN function to work. I get this "the multiplier identifier could not be bound."
What am I doing wrong? Please see the code below.
use ROWDW;
select
store_UIN.HRO, store_UIN.StoreInfo
FORMAT(SUM(total-tax), 'C', 'en-us') AS 'Sales ending 02/06/2016',
COUNT(RO_NO) as 'Car Count',
FORMAT(((SUM((total-tax-t_cost)-(p_cost-supplies))/SUM(total-tax-supplies))), 'P', 'en-us' ) as GPM
from HRO
inner join StoreInfo
on store_UIN.HRO = store_UIN.StoreInfo
where
( PAY_DATE >= '01/31/2016') And (PAY_DATE <= '02/06/2016') and [Status] = 'C'
group by store_UIN
Thanks in advance for your help.