General discussion

Locked

SQL Question - Joins

By JAFA ·
Hello all

I need to perform a query on two tables in SQL Server 2000.

I need to pull everything from table2 with the values from table one, if the type matches use that value, otherwise if the type dosen't match I need to use the value where the type is null.


Example:

Table1 Table2
Style Type Vaule Style Type
---------------- -----------
a <null> 1 a 5
a 1 .9 a 1
a 2 .8 a 3
b <null> 1.1 a 2
b 1 1 b 4
c <null> 1.2 c 4
c 3
c 1

Desired Output
Style Type Value
-----------------
a 5 1
a 1 .9
a 3 1
a 2 .8
b 4 1.1


Any ideas?

Thanks

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by ajsunil In reply to SQL Question - Joins

I hope right outer join can be used in your query

Collapse -

by JAFA In reply to

Poster rated this answer.

Collapse -

by archimede In reply to SQL Question - Joins

I don't have SQLServer here, but the following seems to work in Access:

SELECT T2.Style, T2.Type, (SELECT TOP 1 T1.Value FROM Table1 T1 WHERE
(T1.Type = T2.Type OR T1.Type Is Null) AND T1.Style = T2.Style ORDER BY T1.Type DESC AS MyValue
FROM Table2 T2;

HTH.

Alessandro

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums