Hi, I have 2 simple tables which I have done a left keep and I correctly get this data in one table:
Activity No ForecastID
When my script has only "where ForecastID = 18", it shows up correctly but when I don't use the where clause, all the above data is available. And when I want to select Forecast=18 to filter, I'll just see the first 4. But i would like the first 6. What do I have to do?
How about concatenating those "-" with forecastID individually. So in first steps, join those two tables and in second steps, load those records which doesn't have forecastID and add forecastID manually. For example below,
Create TempLoad table by joining table with forecast table.