Re: SELECT query

On Fri, Apr 13, 2001 at 02:23:50PM -0400, Doug Semig wrote: > Have you thought about normalizing your data model? It could make your > task a lot easier. I have normalized my table structure this is just a practice model i m trying I want that the search should be on username whereby first i search table1 ,then table2,table3 using table4 and displaying unique record > > At 11:33 PM 4/13/01 +0530, Sharmad Naik wrote: > >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 -Regards -- The secret of the universe is @*&í!'ñ^#+ NO CARRIER __ _ _ _ _ |_|_||_||_||\/||_|| \ _|| || || \| || ||_/