How to Join the two table

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » SQL Server Newbies » How to Join the two table

How to Join the two table

Rate Topic

Display Mode

Topic Options

Author

Message

ramanathan.raman88

Posted Saturday, February 02, 2013 2:45 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, May 16, 2013 4:42 AM
Points: 30, Visits: 13

Table 1

A B C D F

A1 B1 NULL NULL NULL
A2 B2 NULL NULL NULL
A3 B3 NULL NULL NULL
A4 B4 NULL NULL NULL
A5 B5 NULL NULL NULL

Table 2

Loc Name

A1 White
A2 Black
A3 Red
A4 Orange
A5 Blue
B1 Green
B2 Yellow
B3 Gold
B4 Rose
B5 Silver

Post #1414927

Sean Lange

Posted Monday, February 04, 2013 8:03 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 3:32 PM
Points: 8,980, Visits: 8,540

Use an OR condition in your join statement?

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Post #1415323

« Prev Topic | Next Topic »

Permissions