bofh5255597
-
Posts
1 -
Joined
-
Last visited
Never
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.
MySQL Full Join
in MySQL Help
Posted
I too have something similar needed
I have accumulated soo much data which is required that I want to break up into yearly tables.
E.g. table2001, table2002 and table2003 etc
I can determine which table to include from a simple check but I need to work out how to join the relevant tables in a select statement
I would of expected a simple asumption by the mysql server when a select * from table2002,table2003 where ... would assume that it should append the data as long as all the fields are the same but I guessed wrong.
How do you get this to work?