Posted by
on 26/06/2011, 23:18
Posted by
on 26/06/2011, 22:50
mysql> CREATE TABLE IF NOT EXISTS tabela_a (
-> id INT(10) NOT NULL UNSIGNED AUTO_INCREMENT,
-> nome VARCHAR(40) NOT NULL,
-> PRIMARY KEY(id));
mysql> CREATE TABLE IF NOT EXISTS tabela_b (
-> id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
-> nome VARCHAR(50) NOT NULL,
-> PRIMARY KEY (id));
SELECT tabela_a.*, tabela_b.* FROM tabela_a INNER JOIN tabela_b ON tabela_a.nome = tabela_b.nome WHERE tabela_a.nome = 'Joao';
+----+------+----+------+
| id | nome | id | nome |
+----+------+----+------+
| 6 | Joao | 5 | Joao |
+----+------+----+------+
Postagens
Male
