Re: Help for construct Query - Mailing list pgsql-novice

From Chris Boget
Subject Re: Help for construct Query
Date
Msg-id 014e01c3b044$63fd1160$8c01a8c0@ENTROPY
Whole thread Raw
In response to Help for construct Query  ("Viaris hotmail" <viaris@hotmail.com>)
List pgsql-novice
> I have the following two tables, the table correo have the messages send
> using the mail, the other table web have the message send using web.
[snip]
> But I need have only one query for both tables, I was trying but I can't,
> how can I do it?

Have you looked into UNION?

Also, are the tables indentical in all but name?  If so, perhaps consolidating
the two tables and add a field to be used to distinguish between the two types
of messages?

Chris


pgsql-novice by date:

Previous
From: "Viaris hotmail"
Date:
Subject: Help for construct Query
Next
From: "Viaris hotmail"
Date:
Subject: Re: Help for construct Query