error in create table from join in Mysql -

error in create table from join in Mysql -

i have 2 tables a , b want bring together using column id , create 3rd table c that. performed query:

create table c select * ( left bring together b using (id))t;

but giving error:

have error in sql syntax; check manual corresponds mysql server version right syntax utilize near 't' @ line 1

i don't know why error coming.

remove following

parenthesis from before select and alias

also

tip, when creating table create table ... select, create sure alias function calls or expressions in query. if not, create statement might fail or result in undesirable column names.

query,

create table c select * left bring together b using (id) sqlfiddle demo create table...select

mysql left-join create-table