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 [EMAIL PROTECTED] ha scritto nel messaggio
news:[EMAIL PROTECTED]
From: Roger
From: Roger Miranda (Sumac) [EMAIL PROTECTED]
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
