Hi,
you could try something like:
INSERT INTO articles_multi(article,author,text_ru,text_en )
SELECT e.article,e.authoer,r.text,e.text
FROM articles_en e, articles_ru r
WHERE e.article = r.article
AND e.author = r.article
/Johan
nullevent wrote:
Hello mysql,
I have two tables - articles_
nullevent <[EMAIL PROTECTED]> wrote:
>
> I have two tables - articles_en and articles_ru.
> Its fields is 'article', 'author', 'text'.
> The difference is - field 'text' in articles_en has english
> text of article and field 'text' in articles_ru has russian text of
> article. Fields 'ar
