Dear all, I need a query as below pasted tables. I expected result for marked as table2 NAME column in Blue & Red based on C_ID1 & D_ID2 and join query as table1. F_ID1 Name F_ID2 110 A 109 TABLE1 103 B 103 105 C 108 1017 D 1017 1023 E 1407 TABLE2 CNAME C_ID1 NAME REMARKS VALUE D_ID2 NAME LEVEL ABC 110 A TEST 1000 103 B SENT BBC 103 B INTERNAL 1000 103 B INTERNAL ABC 1017 D DELIVERY 200000 1407 E FINAL

hi What is your expected result can display in pic? That you show in the pic that is coming from my query .

Sorry... My expecting result as below Thanks

hi whether you need two columns or something else select t2.S_NAME,t2.R_Name from table1 t1 inner join table2 t2 on t1.F_ID1 = t2.C_ID1 Thanks and regards

Hi, Find below image in details and no common fields in both table.

hi I am not getting your point . Whether there are two tables or one table. If two tables wat are the common column for joining? Can describe briefly ? Thanks and regards

Answers

Need sql query for two tables join and two different column

Tamil Selvan

710

1 SQL Server

Dear all,

I need a query as below pasted tables. I expected result for marked as table2 NAME column in Blue & Red based on C_ID1 & D_ID2 and join query as table1.

F_ID1	Name	F_ID2
110	A	109		TABLE1
103	B	103
105	C	108
1017	D	1017
1023	E	1407

				TABLE2

CNAME	C_ID1	NAME	REMARKS	VALUE	D_ID2	NAME	LEVEL
ABC	110	A	TEST	1000	103	B	SENT
BBC	103	B	INTERNAL	1000	103	B	INTERNAL
ABC	1017	D	DELIVERY	200000	1407	E	FINAL

Need sql query for two tables join and two different column

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (6)