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 |
|
ashish908
Starting Member
18 Posts |
 Posted - 2005-05-07 : 06:22:30
|
| I have a itemmaster field with itemid field as the primary key char(10) fieldi have another table say xyz, where there is a column items varchar(50) containing sample data as followsXYZ tableItems I000000001I000000002I000000001,I000000003I want the following query select * from itemmaster where itemid in (select items from xyz)to return all items having itemcode I000000001,I000000002,I000000003, but what is happening it is returning only itemsI000000001,I000000002Is there a way to write a query to return the results inthe format i want__________________ |
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
|
|
|
|
|
comma seperated values in a field query