Query to select matched records from another table in SQL Server

SajidHus...

SOLVED CLOSED ACTIVE ANSWERED
User: SajidHussa
Posted: on Aug 18, 2021 04:17 AM
Forum: SQL Server
Answer: 1
Views: 2108

I make e-commerce medial pharmacy online

there I need SALTS searching men's formula of the medicine

suppose Digene is tablet and its formula is

atenol 250mg

amlodipine 350mg

now i insert a table in record

tbl_salts

pid sid

1 1 (atenol 250mg )

1 2 (amlodipine 350mg )

now this forluma also relted other medicine

like calpon conatine only amlodipine 350mg

now my table is

pid sid

1 1 (atenol 250mg )

1 2 (amlodipine 350mg )

2 2 (amlodipine 350mg )

like so on

pid sid

1 1 (atenol 250mg )

1 2 (amlodipine 350mg )

2 2 (amlodipine 350mg )

3 1 (atenol 250mg )

4 1 (atenol 250mg )

4 2 (amlodipine 350mg )

now if the user select PID one

Digene

so it show aptitude also

4 1 (atenol 250mg )

4 2 (amlodipine 350mg )

not show PID 2 and 3 because it is not an exact formula

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 3

Reply
ANSWER
User: dharmendr
Replied: on Aug 19, 2021 12:21 AM
Modified: on Feb 05, 2022 10:40 AM
Report

Hi SajidHussa,

Refer below query.

CREATE TABLE #Digene(Id INT,formula VARCHAR(500))
INSERT INTO #Digene VALUES(1,'atenol 250mg')
INSERT INTO #Digene VALUES(2,'amlodipine 350mg')

CREATE TABLE #tbl_salts(pid INT,sid INT)
INSERT INTO #tbl_salts VALUES(1,1)
INSERT INTO #tbl_salts VALUES(1,2)
INSERT INTO #tbl_salts VALUES(2,2)
INSERT INTO #tbl_salts VALUES(3,1)
INSERT INTO #tbl_salts VALUES(4,1)
INSERT INTO #tbl_salts VALUES(4,2)

DECLARE @Pid INT
SET @Pid = 1
-- SELECT formula atenol 250mg
SELECT * FROM #tbl_salts WHERE sid = @Pid

SET @Pid = 2
-- SELECT formula amlodipine 350mg
SELECT * FROM #tbl_salts WHERE sid = @Pid

DROP TABLE #tbl_salts
DROP TABLE #Digene

Output

formula atenol 250mg

pid sid

1 1

3 1

4 1

formula amlodipine 350mg

pid sid

1 2

2 2

4 2

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Query to select matched records from another table in SQL Server

Company

Explore

Follow us

Contact Us