Db object.

caroll · #1 (**permalink**) 10-20-10, 07:54

Can we use join while creating DB object?

healdem · #2 (**permalink**) 10-20-10, 08:15

I dunno, why not try it and find out for yourself

it-iss.com · #3 (**permalink**) 10-20-10, 12:32

Hi,

your question is very vague. It is possible to create a table based on a select statement so enhancing the SELECT statement to include a join might work.

Code:

mysql> create table t_select as
    -> select * from test;
Query OK, 3 rows affected (0.08 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql> desc t_select;
+--------+---------------+------+-----+---------+-------+
| Field  | Type          | Null | Key | Default | Extra |
+--------+---------------+------+-----+---------+-------+
| name   | varchar(20)   | YES  |     | NULL    |       | 
| salary | decimal(12,4) | YES  |     | NULL    |       | 
+--------+---------------+------+-----+---------+-------+
2 rows in set (0.01 sec)

mysql> desc test;
+--------+---------------+------+-----+---------+-------+
| Field  | Type          | Null | Key | Default | Extra |
+--------+---------------+------+-----+---------+-------+
| name   | varchar(20)   | YES  |     | NULL    |       | 
| salary | decimal(12,4) | YES  |     | NULL    |       | 
+--------+---------------+------+-----+---------+-------+
2 rows in set (0.01 sec)

The table t_select did not exist before the create table statement.