I found something really interesting: In Oracle, I have to create the Foreign Key in order to join 2 tables. It's quite different when I deal with MySQL. I can join two tables without creating the Foreign Key. ----- Is this Normal? Before learning MySQL, I thought both MySQL and Orcle use Structural Query Language, which should be the same. But, now I know I'm wrong.
That's because MySQL does not have foreign keys by default. You have to install InnoDB tables to use foreign keys, transactions etc.
Kaarel
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]