Re: [PHP-DB] mysql table join

2005-02-06 Thread franciccio
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 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 Holmes... 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP-DB] mysql table join

2003-11-20 Thread CPT John W. Holmes
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 Holmes...

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php