insert into tablea if conditions meet data from tableb?

[onedumbcoder]

is it possible to do something like this?

INSERT INTO tablea(a,b,c) VALUES('1','2','3') USING tablea INNER JOIN tableb WHERE tableb.id = 'dfsf' AND tableb.password='dfsd'

 

if so can u please provide the correct syntax?

[Gamic]

You could do something like this:

insert into tablea(a,b,c)
select a, b, c from
(
select 
	'1' as a,
	'2' as b,
	'3' as c,
	'someID' as id,
	'somepassword' as password
) as tmp
inner join tableb on tableb.id = tmp.id and tableb.password = tmp.password