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
got
an example
lying around of how to do it with temporary tables.
Rhino
- Original Message -
From: "Nurullah Akkaya" <[EMAIL PROTECTED]>
To:
Sent: Saturday, October 08, 2005 8:43 PM
Subject: selecting from 2 tables
i have two tables one of them is a que of url
mple
lying around of how to do it with temporary tables.
Rhino
- Original Message -
From: "Nurullah Akkaya" <[EMAIL PROTECTED]>
To:
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
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..
Nurul
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
---
2001 11:05 AM
To: [EMAIL PROTECTED]
Subject: Selecting * from 2 tables
Hello list,
How would you go about selecting * from 2 tables?
I have 2 tables: table_1 and table_2
In table_1 I have the following data.
dog
bird
cat
In table_2 I have:
mouse
rat
hampster
How do I show both tables content
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
field named animalType in both tables
and they are the same type and size.
HTH,
Cal
http://www.calevans.com
-Original Message-
From: Mike Mike [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 26, 2001 1:05 PM
To: [EMAIL PROTECTED]
Subject: Selecting * from 2 tables
Hello list,
How would y
Hello list,
How would you go about selecting * from 2 tables?
I have 2 tables: table_1 and table_2
In table_1 I have the following data.
dog
bird
cat
In table_2 I have:
mouse
rat
hampster
How do I show both tables contents like:
+--+
|dog |
|bird |
|cat |
|mouse
