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 |
|
prasadsql
Starting Member
6 Posts |
 Posted - 2009-12-01 : 05:06:24
|
| I have 2 tables, 1 contain 3 records and other contain 3 recordsI want to join these table, but when i join records are repeated.I want to avoid repeated records.Which JOIN join these 2 table & show only 3 record |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2009-12-01 : 07:06:09
|
| select * from table1 ainner join table2 b on a.id = b.id |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-12-01 : 07:45:02
|
| Why is without a condition?MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Join without condition