SELECT monitorhosts.HostID
FROM monitorhosts, monitorhostgroupdetails
WHERE monitorhosts.HostID = monitorhostgroupdetails.HostID
AND monitorhostgroupdetails.HostGroupID != '1');
Gruss
Sabine
Chris Knipe wrote:
Lo all,
are sub-queries supported on mysql-max 3.23.49 ??
If they are,
And how long does it take to compile a 32-tables-statement?
With the gupta server a 14-tables-statement took 2 hours.
Sabine
Weaver, Walt wrote:
Hmmm... we're running 3.23.47 here and have run into a 32 table join
limit...
--Walt
-Original Message-
From: Roger Baklund
Sorry,
I've been too long in a list where you just answer the questioner and
then the questioner writes a summary of the answers to the list.
Sabine
Sabine Richter wrote:
Hello Taylor,
as far as I see from the documentation and own trials you can just
delete from table where
Sorry,
I've been too long in a list where you just answer the questioner and
then the questioner writes a summary of the answers to the list.
Sabine
Sabine Richter wrote:
Hello Alexander,
your problem is near to Taylor Lewick's and I have a similar suggestion
for you:
1) create newtab
Sorry,
I've been too long in a list where you just answer the questioner and
then the questioner writes a summary of the answers to the list.
Sabine
Sabine Richter wrote:
Hi Ron,
I suspect users.id and userid1 / userid2 have to be joined?
Then:
select your_desired_cols
from users
Hello,
I just want to get the value of one column in the row where max of
another col of this table is.
With the possibility of sub queries I would write:
select col1
from table t1
where col2 = (select max(col2)
from tab1e t2);
But how to do it without a sub query?
Just with 1
from table t1, table
t2 where =max(col2) result in the same error reports
Perhaps someone else has an idea?
Best regards
Sabine
Philip Spradling wrote:
I could be missing something, but what about:
select col1 from t1 where col2 = max(col2);
On Sun, 12 May 2002 23:04:14 +0200
Sabine
Hello,
I can't think straight today. So please help me:
I downloaded and installed myODBC 3.51. As far as I understand, it is
only the driver, which provides the connection to the database. In my
example, it is MySQL 3.23.49.
The manual says that in my application I have to allocate the
number means, where to find
something about it (who raised it: win or mysql?) and where to search
for the reasons. I already searched for this failure in the mysql ref
manual and in the win help system.
I'll be grateful for any tip!
Thanks in advance
Sabine Richter
Hi Jan,
I suppose you already tried this:
http://www.mysql.com/doc/N/T/NT_start.html
I did!
This could be problems w/ your path or your my.ini (overwritten my
mysqladmin).
mysqld-nt --help has the correct basedir (.\mysql\) Oh, what's that?
In my.ini I just wrote basedir=mysql
oops, i've just sent it to mike.
Sabine Richter wrote:
Hello Mike, hello Silvia,
I think, the statement you suggest, Mike, isn't right. It gives you only
patients who are over 1 year in hospital. That means, who came before
(or at) 2000-01-25 and left after (or at) 2001-01-30. I think
11 matches
Mail list logo