RE: SQL help (updated)

2005-08-17 Thread Dave.Phillips
That probably needs to be WHERE #idnumber# IN (MyColumn) Ian, Yes, I tried that. I had typoed my e-mail, but in my code I had the parenthesis. That's what give the invalid comparison error. It doesn't seem to recognize the field. Dave

RE: SQL help (updated)

2005-08-17 Thread Dave.Phillips
: Tuesday, August 16, 2005 4:37 PM To: CF-Talk Subject: Re: SQL help (updated) You realize that this is essentially a db design issue - right? The table shouldn't be holding lists of numbers - there should be a join table that does that job. Right? On 8/16/05, [EMAIL PROTECTED] [EMAIL PROTECTED

RE: SQL help (updated)

2005-08-16 Thread Dave.Phillips
Okay, I still need help, but I've resolve part of my problem. I'm able now to have the list of ID numbers in one field by themselves. So, my new field value (MyColumn) looks like this: '5,2,3,4,45,7' I still need a way using Query of Queries to extract only the records that have the

RE: SQL help (updated)

2005-08-16 Thread Ian Skinner
SELECT * FROM AllResults WHERE #idnumber# in MyColumn That probably needs to be WHERE #idnumber# IN (MyColumn) The values of an IN clause are supposed to be in parenthesis I believe. You may also need to do something about the quotes if they are

Re: SQL help (updated)

2005-08-16 Thread Jochem van Dieten
[EMAIL PROTECTED] wrote: Okay, I still need help, but I've resolve part of my problem. I'm able now to have the list of ID numbers in one field by themselves. So, my new field value (MyColumn) looks like this: '5,2,3,4,45,7' I still need a way using Query of Queries to extract only

Re: SQL help (updated)

2005-08-16 Thread Deanna Schneider
You realize that this is essentially a db design issue - right? The table shouldn't be holding lists of numbers - there should be a join table that does that job. Right? On 8/16/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Okay, I still need help, but I've resolve part of my problem. I'm able

RE: SQL Help (updated)

2004-02-01 Thread Stephen Hait
Had some incorrect info in there Carry on:-) Given the following journals with related documents. Journal A document1a - Jan 1, 2004 document2a - Jan 2, 2003 document3a - Dec 3, 2002 Journal B document1b - Jan 3, 2001 document2b - Jan 4, 2000 document3b - Dec 2, 1999

RE: SQL Help (updated)

2004-01-30 Thread Tangorre, Michael
Had some incorrect info in there Carry on:-) Given the following journals with related documents. Journal A document1a - Jan 1, 2004 document2a - Jan 2, 2003 document3a - Dec 3, 2002 Journal B document1b - Jan 3, 2001 document2b - Jan 4, 2000 document3b - Dec 2, 1999 Journal C