thx worked great..
Nurullah Akkaya What lies behind us
and what
[EMAIL PROTECTED] lies before us are tiny matters
Registered Linux User #301438 compared to what lies within us.
WARNING all messages "If at first an idea is not
containing attachments absurd, there is no hope for it"
or html will be silently Albert Einstein
deleted. Send only
plain text.
Because the people who are crazy enough to think
they can change the world, are the ones who do.....
On Oct 8, 2005, at 11:28 PM, Rhino wrote:
If you are using a version of MySQL that supports subqueries, you
can do
something like this:
select * from unprocessed_url_table
where url not in (select url from processed_url_table)
In other words, the inner query (the part in brackets) is returning
a list
of all the URLs that have been processed, according to the table
which lists
the processed URLs; the rest of the query is getting rows of tables
whose
URLs have *not* been processed.
I *think* MySQL V4.1.x supports subqueries but I might be wrong;
perhaps
only V5.x supports it. I'm afraid I haven't been doing much with MySQL
lately and forget exactly when each feature was made available.
If you don't have a version that supports subqueries, it should be
possible
to do what you want a different way, probably with temporary
tables. Ask
again in you need to know how to do it that way. I think I've got
an example
lying around of how to do it with temporary tables.
Rhino
----- Original Message -----
From: "Nurullah Akkaya" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Saturday, October 08, 2005 8:43 PM
Subject: selecting from 2 tables
i have two tables one of them is a que of urls and the other is list
of urls that have been processed
now i want to select a url from Que that is not in the processed urls
table how can i do this in one select i do not want my application to
do two seperate select statements?
thx..
Nurullah Akkaya What lies behind us
and what
[EMAIL PROTECTED] lies before us are tiny matters
Registered Linux User #301438 compared to what lies within us.
WARNING all messages "If at first an idea is not
containing attachments absurd, there is no hope for it"
or html will be silently Albert Einstein
deleted. Send only
plain text.
Because the people who are crazy enough to think
they can change the world, are the ones who do.....
----------------------------------------------------------------------
------
----
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.13/124 - Release Date:
07/10/2005
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.13/124 - Release Date:
07/10/2005
