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 |
|
lfmn
Posting Yak Master
141 Posts |
 Posted - 2001-03-19 : 20:46:29
|
| I'm trying to join a table to itself to get the following outputCOLUMN1 COLUMN2item1 other5item2 other6item3 other7item4 other8I've tried the following:select a.item as column1, b.item as column2from syscolumns a, syscolumns bwhere a.id = b.idand a.id = 545654and a.item like '%item%'and b.item like '%other%'I know I'm leaving something out, but can't remember what it is. I'm getting 16 rows returned instead of 4.Any help would be appreciated.lfmn |
|
|
|
|
|
joining a table to itself