4,707 questions
Hi MuhammadNaeem，
Please refer to this article：
Supertype and subtype tables in SQL Server
Best Regards
Echo
Select Data from supertype and subtype?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 37%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMN%3C/text%3E%3C/svg%3E)
Muhammad Naeem
1
Reputation point
How i can select data from supertype and subtype in sql server?
Any query?
Developer technologies Transact-SQL
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 76%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEM%3C/text%3E%3C/svg%3E)
EchoLiu-MSFT 14,621 Reputation points2020-08-28T07:50:26.387+00:00 Hi @Muhammad Naeem ，
Has your problem been solved? If it is solved,please remember to accept the answers if they helped. This can help others who encounter similar problems..
Best Regards
Echo
Sign in to comment
2 answers
Sort by: Most helpful
-
EchoLiu-MSFT 14,621 Reputation points
2020-08-24T07:13:06.343+00:00 -
Olaf Helper 47,436 Reputation points2020-08-24T08:01:17.027+00:00 What exactly do you mean with supertype & subtype; can you post an example?
Olaf