Hi, I have Table a with column id, and table B with column id2. I want to select a couple columns from A and from b including those id columns. However, If the A.id IS NULL then I would like to use the B.id2 and write these value to the same column in a new 3rd table. Is this possible? Thank lyou.
The query is what I have currently.
Select A.[Name] as [Interest], A.ParentResearchInterest_id as RchChildId, B.ApplicationId as ApplicationId
from dbo.ResearchInterests A
FULL JOIN dbo.tmpCtsiRcshInt B
ON A.Id = B.[ApplicationId]