| From: | Sharmad Naik <sharmad(at)goatelecom(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | SELECT query |
| Date: | 2001-04-13 18:02:41 |
| Message-ID: | 20010413233241.A844@goatelecom.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
I have three table called table1, table2, table3 all having fields like:
table1 contain id and username and id referencing table4
table2 contains id and parallel_username and id referencing table4
table3 contains id and other_username and id referencing table4
table4 is the main table containing id as primary key
I want to develop a search engine which shows unique record after searching
all the three table but shouldn't contain multiple answers for same SEARCH for
username
Pls help me,
-Regards,
Sharmad
--
The secret of the universe is @*&í!'ñ^#+ NO CARRIER
__ _ _ _ _
|_|_||_||_||\/||_|| \
_|| || || \| || ||_/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-04-13 18:35:49 | Re: Calling plSQL functions |
| Previous Message | Peter Eisentraut | 2001-04-13 16:52:40 | Re: BOOLEAN data type? |