Nick,
select * from endOfDayData where endOfDayData.market like 'NYMEX'
and endOfDayData.symbol IN (select names.symbol from names where
names.market like 'NYMEX' and names.name like 'natural gas {%');
Query c seems to have good syntax as neither the command line mysql
interface nor the gui s
Nick Torenvliet wrote:
Hey all...
I am having a problem with sub-queries that I cannot trouble shoot.
I run query a:
select symbol from names where market like 'NYMEX' and name like 'natural
gas {%';
and get 168 names that I manually insert into query b:
select * from endOfDayData where endO
In the last episode (Jan 19), Nick Torenvliet said:
> Hey all...
>
> I am having a problem with sub-queries that I cannot trouble shoot.
>
> I run query a:
> select symbol from names where market like 'NYMEX' and name like 'natural
> gas {%';
>
> and get 168 names that I manually insert into qu
Hey all...
I am having a problem with sub-queries that I cannot trouble shoot.
I run query a:
select symbol from names where market like 'NYMEX' and name like 'natural
gas {%';
and get 168 names that I manually insert into query b:
select * from endOfDayData where endOfDayData.market like 'NYM
Thanks for the detailed feedback. I do not create the data so I can't
modify it. Your illustration of the table is correct. I'll try to
implement some of your feedback.
Thanks
On 9/25/06, Michael Stassen <[EMAIL PROTECTED]> wrote:
Jeff Drew wrote:
> I have a query with a subquery which does
Jeff Drew wrote:
> I have a query with a subquery which does not throw an error, but does not
> return either. I've been testing the query using mysql Query Browser and
> the poor dolphin jumps only once a minute or so ;) I use MYSQL's
> excellent error documentation heavily so if the query do
I have a query with a subquery which does not throw an error, but does not
return either. I've been testing the query using mysql Query Browser and
the poor dolphin jumps only once a minute or so ;) I use MYSQL's excellent
error documentation heavily so if the query doesn't throw an error, I'm
