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.
Author |
Topic |
sturner333
Starting Member
22 Posts |
Posted - 2014-10-07 : 10:44:52
|
I have 2 tables. Based on the Table1 id which is a column in Table2, I would like the followingTable1T1_Id 1 234 Table2 T2_ID T1_ID Color1 3 red2 3 blue3 1 green4 1 orangeResultJust the records 3 and 1 from table1Thanks for the help |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-10-07 : 12:05:47
|
This is clearly a homework question, so please show us what you have so far.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|