Re: mysql table join

You may try to create a VIEW. In this case the tables will be dynamically linked, that is when some values change in both tales the views automatically update itself each time you call it. "CPT John W. Holmes" <holmes072000@charter.net> ha scritto nel messaggio news:007201c3afac$99bde2e0$a629089b@tbhhccdr... > From: "Roger Miranda (Sumac)" <rogerm@sumacclothing.com> > >> Is there a way to permanently join/link two mysql tables? > > Not without creating another table. > > CREATE TABLE MyTable SELECT ... FROM Table1 JOIN Table2 ON ... WHERE ... > > Although I have to wonder about your schema if you need to do this. > > ---John Holmes...