Nurullah Akkaya <[EMAIL PROTECTED]> wrote on 10/08/2005 08:43:27
PM:
> 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
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 att
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 proces
You can create a "MERGE TABLE" (read all about it in the manual)...
CREATE MERGE TABLE everything ( animalname varchar(25)) TYPE=MERGE
UNION=(table_1,table_2);
Thereafter, you can select * from everything;
Cheers,
Kent Hoover
---
assuming that each table only has one element, you could do a select * from
2 table.
If you don't and you need to combine everything, then you're trying to do a
UNION.
mySQL doesn't support UNION's yet.
one way to do a union is to create a temporary table then use two queries to
fill the
tempo
Hi i think
SELECT table1.*, tabla2.* FROM table1, table2
-Mensaje original-
De: Mike Mike [mailto:[EMAIL PROTECTED]]
Enviado el: Friday, January 26, 2001 11:05 AM
Para: [EMAIL PROTECTED]
Asunto: Selecting * from 2 tables
Hello list,
How would you go about selecting * from 2 tables?
I
You can't do
select * from table_1 UNION select * from table_2;
1st the structures of both queries have to be exactly the same. Second, you
have to specify them in the select.
select animalType from table_1 UNION select animalType from table_2;
should work, assuming that you have a field named
