which join here use - 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

Transact-SQL (2000)

which join here use

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-11-04 : 08:45:29

Nilesh Ramesh Sawant writes "Dear sir,

Hi,

Last two day i have some problem, please help me.

i have three table
1)Product
ProductID, ProductName, CategoryID

2)Feature
FeatureID, FeatureName, CategoryID

3)ProductFeature
ProductFeatureID, FeatureID, ProductID, ProductValue

follwing view i want(no duplicate value should be display there) - When any category select this view show if that category any features avilable

Feature.FeatureID | Feature.Label | ProductFeature.ProductValue
1 | L | 34
2 | L1 | 34
3 | L2 | 35"

nr
SQLTeam MVY

12543 Posts

Posted - 2004-11-04 : 08:48:53

select distinct f.FeatureID, f.FeatureName, pf.ProductValue
from Feature f
join ProductFeature pf
on f.FeatureID = pf.FeatureID

But I suspect there's something you're not telling us.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2004-11-04 : 09:08:30

Do you want a stored procedure? Do you need to accept a parameter and return information based on that parameter?

- Jeff

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources