Help with query - 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

General SQL Server Forums

New to SQL Server Programming

Help with query

Author

Topic

turtle1353
Starting Member

9 Posts

Posted - 2007-04-04 : 19:36:21

Hello SQL gurus, could you kindly help me with this query?


Table1
Expr1
AAA
BBB
DDD

and...


Table2
Item_in | Add
AAA        n 
BBB        n
CCC        n
DDD        n

and I'm trying to output...


Item_in | Add | Expr1
AAA        n    AAA  
BBB        n    BBB
CCC        n    (Null) Or some generic value
DDD        n    DDD

Thanks in advance.

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2007-04-04 : 19:44:05

If you don't know how to do that, you may need to Learn SQL:
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

CODO ERGO SUM

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-04-04 : 19:45:30

Hint: OUTER JOIN

Tara Kizer
http://weblogs.sqlteam.com/tarad/

turtle1353
Starting Member

9 Posts

Posted - 2007-04-04 : 19:52:20

haha! thanks for the tip! well, it's a newbie forum right? You're right, I gotta learn this stuff =) thank you!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources