Can a Column in a table pick up data from Another Table in SQL Server

I have a table PatientChartImages. It 开发者_运维技巧has a column ChartImage, which contains the binary of images. Now, we are planning to create a separate table which will contain the Binary of Images and will join both the tables to get requisite data. Now, we do not want to change the front end and I cannot use triggers. So, is there any way by which if a query refers to ChartImage column of PatientChartImages, it picks data from the third table? Please suggest.

I think inner-join does this. I've only overheard it's use - but this might lead you towards your answer.