Re: Insert data from CONCAT data from one table using select statement into new table

[Peter Brawley]

Well, check the data it's looking at, eg ...

select p.username, u.idnumber, p.idnumber
from username u left join persons p using(idnumber);

select p.username, p.idnumber, u.idnumber
from persons p left join usdername u using(idnumber);