How to get description? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

How to get description?

Author

Topic

larraw
Starting Member

1 Post

Posted - 2005-07-25 : 14:44:33

I have a sql statement which is working:

SELECT DISTINCT T1.ATCkod FROM ATC_tot T1 JOIN ATC_tot T2 ON T2.ATCkod = T1.ATCkod and T2.Typ_lakemedel LIKE '%' + @Kod2 + '%' JOIN ATC_tot T3 on T3.ATCkod = T1.ATCkod AND T3.Typ_lakemedel LIKE '%' + @Kod3 + '%' WHERE T1.Typ_lakemedel = @Kod

I would like to get a description from a table atc_desc where ATCkod = ATC_tot.ATCkod, I have tried without success! Any good ideas someone?

Wanderer
Master Smack Fu Yak Hacker

1168 Posts

Posted - 2005-07-25 : 15:55:28

I *think* this might be what you are looking for.


select
	atcd.Description
from
	atc_desc atcd
	inner join
	(SELECT 
		DISTINCT T1.ATCkod 
	FROM 
		ATC_tot T1 
		JOIN 
		ATC_tot T2 
			ON T2.ATCkod = T1.ATCkod 
			and T2.Typ_lakemedel LIKE '%'+@Kod2+'%' 
		JOIN 
		ATC_tot T3 
			on T3.ATCkod = T1.ATCkod 
			AND T3.Typ_lakemedel LIKE '%'+@Kod3+'%' 
	WHERE T1.Typ_lakemedel = @Kod) Kod
	on atcd.ATCkod = Kod.ATCkod

Are you sure you need to be doing those self joins? It almost seems like you could be doing:


select
	atcd.Description
from
	atc_desc atcd
	inner join
	ATC_tot AT
		on atcd.ATCkod = AT.ATCkod
where 
	AT.Typ_lakemedel LIKE '%'+@Kod2+'%' 
OR 	AT.Typ_lakemedel LIKE '%'+@Kod3+'%' 
or	AT.Typ_lakemedel = @Kod    --<-- some logic I am missing here - brains says it ain't right...

*##* *##* *##* *##*

Chaos, Disorder and Panic ... my work is done here!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources