Display id and name for salesmen along with id and category of products in a single table. Indicate the source of the row in result by adding an additional column TYPE with possible values as ‘S’ (Salesman) and ‘P’ (Product). Display all rows.
I don’t how to add column “type” without using alter
x
select sid AS ID,sname from salesmanunionselect category as "DETAILS" from productactual tables are
Salesman Table
SID SNAME LOCATION1 Peter London2 Michael Paris3 John Mumbai4 Harry Chicago5 Kevin London6 Alex ChicagoProduct Table
PRODID PDESC CATEGORY DISCOUNT101 Basketball Sports 5102 Shirt Apparel 10103 NULL Electronics 15104 CricketBat Sports 20105 Trouser Apparel 5106 Television ELECTRONICS 20expected output
TYPE ID DETAILSP 101 SportsP 102 ApparelP 103 ElectronicsP 104 SportsP 105 ApparelP 106 ELECTRONICSAdvertisement
Answer
You want result like this?
TYPE ID DETAILSS 1 PeterS 2 MichaelS 3 JohnS 4 HarryS 5 KevinS 6 AlexP 101 SportsP 102 ApparelP 103 Electronics.You can try query like this
select 'S' AS TYPE, sid AS ID,SNAME AS DETAILS from Salesmanunionselect 'P' As TYPE, PRODID, category as "DETAILS" from Product