No data in the column which I add from another table

[Heath Wu]

Hi,

I have two tables A and B. TableA includesdetailed production data andhas a columncalled 'Program Name'. TableB is a table only about program information and of course has the column 'Program Name' as well. In table A, I added several columns from table B by matching these two 'Program Name' columns, and using left outter single match. After column added, there is no data in these newly added columns at all. Just empty columns. I have checked thatmost of the data in these two 'Program Name' columns is same.What would possibly be the reason of no data showed in added columns Thanks.

Heath

[Nawaz Ali Mohammad]

There could be high chances that the column "Program Name" might have extra trailing spaces. Try removing extra spaces if any in Program Name column.