SQL Query

Question

Hi All,I have 2 tables ConfigurationTable and Data table. I require combine value like below outputSource tables:Target Output:Sql Scripts:CREATE TABLE CONFIGTABLE(Productcode VARCHAR(10), &nbsp; &nbsp;Linkedvalue VARCHAR(10))INSERT INTO CONFIGTABLE VALUES ('A', &nbsp; &nbsp;'PEN'),('C', &nbsp; &nbsp;'PENCIL'),('B', &nbsp; &nbsp;'BOOK'),('M', &nbsp; &nbsp;'MOUSE')CREATE TABLE DATATABLE (FIELDVALUE VARCHAR(50), &nbsp; &nbsp;ORDERID INT,NAME VARCHAR(20))INSERT INTO DATATABLE VALUES ('321', &nbsp; &nbsp;9, &nbsp; &nbsp;'COMPUTER'),('THIS PEN IS', &nbsp; &nbsp;1, &nbsp; &nbsp;'A'),('Country', &nbsp; &nbsp;5, &nbsp; &nbsp;'BOOK'),('Great village in a', &nbsp; &nbsp;4, &nbsp; &nbsp;'B'),('MINE', &nbsp; &nbsp;2, &nbsp; &nbsp;'PEN')

rodgerkong · Accepted Answer

Combine two values is easy, but I don't know how to order result like your sample.SELECT 
	C.Productcode +':' + C.Linkedvalue AS [Combine Of Productcode and Linkedvalue], 
	K.FIELDVALUE + ':' + V.FIELDVALUE AS [VALUE]
FROM CONFIGTABLE C
LEFT JOIN DATATABLE K
	ON C.Productcode = K.NAME
LEFT JOIN DATATABLE V
	ON C.Linkedvalue = V.NAME&nbsp;

Forum Discussion

SQL Query

2 Replies

Resources