Display Unique Products and Manufacturers in an external MS SQL system?

Question

SQL Server

Assortement + ExternalCod + ExternalSystem (SQL Server)
There is a main table Assortment of the store, and from it 2 tables Externol Code and Extrenol systems, it seems like I was told these are the parameters or what kind of tables I don’t know, so here’s how it should be, linking it all or not all display all unique products from the external system, as well as all unique manufacturers from the external system, as well as a separate request with a request for a list of these products that is

Answer 1

SELECT DISTINCT .
A MS_Descriptionis the description of the table.