| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: need help |
| Date: | 2013-08-16 18:11:55 |
| Message-ID: | 520E6B6B.9060600@hogranch.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 8/16/2013 6:35 AM, Basavaraj wrote:
> finally the result shoule be
>
> name| address|email|mobileNo|firstname|lastName|
> --------------------------------------------------
> abc some1 mail1 1234564 def xyz
>
> 5 records | 10 records
>
> |
First, a table is an unordered SET of tuples(rows). it only has an
order when one is applied to it. so which rows of table 1 would go
with what rows of table 2?
Second, if that 2nd table has 10 records and the first table only has 5,
what would those other 5 look like in your example? no answer I can
think of makes sense. all rows of a recordset have to have the same
fields.
If this data is unrelated, then it does not belong together in a relation.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Janes | 2013-08-16 18:21:24 | Re: Does string a begin with string b? |
| Previous Message | Robert James | 2013-08-16 18:04:18 | Does string a begin with string b? |