How to simulate FULL JOIN with MYSQL

2003-02-19 Thread Michael Katzmann
I have a database with tables representing data from various years 1997, 1998, 1999, 2000 etc. In the tables I have data representing widget sales, zip codes, types of widgets, for example. Not all widget types were sold in every year, so there are entries in some tables that don’t occur in

Re: How to simulate FULL JOIN with MYSQL

2003-02-19 Thread Diana Soares
Hi, On Wed, 2003-02-19 at 15:56, Michael Katzmann wrote: I have a database with tables representing data from various years 1997, 1998, 1999, 2000 etc. In the tables I have data representing widget sales, zip codes, types of widgets, for example. Not all widget types were sold in every year,