All fields must be at the same position and the same data type, you can make all kind of selects, joins, where etc the UNION ALL comand is best then UNION if you want select all rows if they are the same**, this is not the case in this sample, you can make it a View.
source https://www.c-sharpcorner.com/Blogs/using-union-with-differents-tables-fields-and-filtering
No comments:
Post a Comment