IN Clause: Using Field Values - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

IN Clause: Using Field Values

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-05-03 : 08:34:21

Ken writes "I am trying to use a table field to populate the IN clause of my statement. For example, I have a table with two fields name and set, i.e

name set

Jules 'Jules','Ken'
Tom 'Jules','Ken'

I would like to peform the following function

SELECT tbl.name, tbl.set
FROM tbl
WHERE tbl.name IN (tbl.set);

Oh yes, I am using MS Access. In doing so, it treats "tbl.set: as the list. I have tried to use the string ('Jules','Ken') as tbl.set, then

SELECT tbl.name, tbl.set
FROM tbl
WHERE tbl.name IN tbl.set;

but then, I recieve the msg that, I a missing quotes.

Is what I am attempting, do-able at all? "

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources