Re: Help for construct Query

From: "Chris Boget" <chris(at)wild(dot)net>
To: "Viaris hotmail" <viaris(at)hotmail(dot)com>, <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Help for construct Query
Date: 2003-11-21 15:30:27
Message-ID: 014e01c3b044$63fd1160$8c01a8c0@ENTROPY
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Viaris hotmail 2003-11-21 15:47:10 Re: Help for construct Query
Previous Message Viaris hotmail 2003-11-21 15:22:43 Help for construct Query