RE: Stumped on a query

2004-01-20 Thread Ted . A . Gifford
Asplund [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 20, 2004 1:26 PM To: Chris Boget Cc: [EMAIL PROTECTED]; MySQL Subject: Re: Stumped on a query On Tue, 20 Jan 2004, Chris Boget wrote: > > > The data I'm working with looks like this: > > > table1.columnA = '1;3;4

Re: Stumped on a query

2004-01-20 Thread Tobias Asplund
On Tue, 20 Jan 2004, Chris Boget wrote: > > > The data I'm working with looks like this: > > > table1.columnA = '1;3;4;6;8;9;12;13;14;15'; > > > table2.columnA = '3'; > > > table2.columnB = 'this'; > > > I need to write a query that will do something along these lines: > > > SELECT * FROM table1,

Re: Stumped on a query

2004-01-20 Thread Fred van Engen
On Tue, Jan 20, 2004 at 03:02:45PM -0600, Chris Boget wrote: > > > The data I'm working with looks like this: > > > table1.columnA = '1;3;4;6;8;9;12;13;14;15'; > > > table2.columnA = '3'; > > > table2.columnB = 'this'; > > > I need to write a query that will do something along these lines: > > > SE

Re: Stumped on a query

2004-01-20 Thread Chris Boget
> > The data I'm working with looks like this: > > table1.columnA = '1;3;4;6;8;9;12;13;14;15'; > > table2.columnA = '3'; > > table2.columnB = 'this'; > > I need to write a query that will do something along these lines: > > SELECT * FROM table1, table2 WHERE > > table2.columnB = 'this' > > AND >

Re: Stumped on a query

2004-01-20 Thread Tobias Asplund
On Tue, 20 Jan 2004, Chris Boget wrote: > The data I'm working with looks like this: > > table1.columnA = '1;3;4;6;8;9;12;13;14;15'; > > table2.columnA = '3'; > table2.columnB = 'this'; > > I need to write a query that will do something along these lines: > > SELECT * FROM table1, table2 WHERE >