STORE TABLE has column "Store Key" and "Store Num", but ORDER TABLE only has "Store Num".
I joined "Store Key" from STORE TABLE to ORDER TABLE, but realized that each "Store Num" is linked to several "Store Key" based on "Store End Date". So I wrote a join statement in SQL then saved it as view.
But when I tried to connect to the SQL view through ODBC, it showed the following message, please help me check the following code and let me know where I did wrong , THANK YOU!!