27
27
CREATE TABLE t1 (id int(3) default NULL, data varchar(255) default NULL);
28
28
INSERT INTO t1 VALUES (1,'male'),(2,'female');
30
30
INSERT INTO t2 VALUES (1,'yes'),(2,'no');
32
32
select t1.id, t1.data, t2.data from t1, t2 where t1.id = t2.id;