What would be the best process to union two tables together based on if Table A has data I would only pull data from Table B?
SELECT Column A, Column B, Column C FROM Table A
union
Select Column A, Column B, Column C FROM Table B
So in the end I need to union two tables but only pull data if data is returned from Table A.
SELECT Column A, Column B, Column C FROM Table A
union
Select Column A, Column B, Column C FROM Table B
So in the end I need to union two tables but only pull data if data is returned from Table A.