> Michael Ansley wrote:
>
> INSERT INTO table3 (id, surname, dt) SELECT table1.id, table1.surname,
> table2.dt FROM table1, table2;
> or
> CREATE TABLE table3 AS SELECT table1.id, table1.surname, table2.dt
> FROM table1, table2;
>
> It's called a cross-join.
You are absolutely right.
But I don't find any information about JOIN in SELECT sentences. :(
Could you give me example of LEFT or RIGHT JOIN.
Best regards,
Mik.