MySQL - INNER JOIN

mysql> CREATE TABLE user

       (id INT NOT NULL AUTO_INCREMENT KEY,

       name CHAR(20));

mysql> CREATE TABLE sayur

       (id INT NOT NULL AUTO_INCREMENT KEY,

       name CHAR(10),

       uid INT);

mysql> SELECT user.name, sayur.name FROM user,sayur WHERE user.id

       = sayur.uid

MySQL - INNER JOIN