From: Ligaya Turmelle Date: October 4 2005 11:36pm Subject: Re: Joins Tutorial Anywhere? List-Archive: http://lists.mysql.com/mysql/189974 Message-Id: <43431213.60905@maolek.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit bit simplistic but http://sqlcourse2.com/joins.html Rich wrote: >Hi folks. Any chance on a tutorial from joins? I find them totally >confusing and I know there's some power in them, so I need to learn them. > >Having asked that, another question arises...do my field names in different >tables within the same database have to overlap (same field name) in order >for joins to work? I'm currently naming fields in such a manner: > >TABLE1 >table1_alpha >table1_bravo > >TABLE2 >table2_firstname >table2_lastname > >Appreciate any guidance on these two questions. > >Cheers > > > > > -- Respectfully, Ligaya Turmelle "Life is a game.... so have fun"