From: Peter Brawley Date: November 19 2005 11:24pm Subject: Re: BIIIIIIIIIIG query List-Archive: http://lists.mysql.com/mysql/191910 Message-Id: <437FB43C.1010602@earthlink.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit Hi Rhino, I believe I have seen full outer join on a 5.1 to-do list, but at the moment I can't recall where. PB ----- Rhino wrote: > Paul, > > Do you have any idea if MySQL plans to support full outer joins at > some point in the future? I realize you can probably fake them without > having the syntax available but it would be nice to be able to get > them directly.... > > Rhino > > ----- Original Message ----- From: "Paul DuBois" > To: "bruno b b magalhães" ; "MySQL List" > > Sent: Saturday, November 19, 2005 12:05 PM > Subject: Re: BIIIIIIIIIIG query > > > At 12:51 -0200 11/19/05, bruno b b magalhães wrote: > >> Hi guys, >> >> I need some help with an query that I know I must use joins, but I >> can't figure out how to. >> >> The problem is, when the contact has an address, phone and email it >> works just fine, but I want it to display those how doesnt also! >> Could someone with JOINs experience help me? >> >> And one more question, how compatible are joins? I mean, the >> environment I am developing in is MySQL 4.1, but some of my clients >> are using 4.0.25 and others are using 5.0. > > > Re: compatibility, it would be a good idea to read this section of the > Reference Manual with regard to the changes made to join processing in > MySQL 5.0.12 for compliance with standard SQL: > > http://dev.mysql.com/doc/refman/5.0/en/join.html > -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.13.4/175 - Release Date: 11/18/2005