Joins

[New-here1]

Hello, 

I have 2 tables that I would like to join together

Table 1: ID

1234

Table 2: Name

Book 

I would like the data in the table to join together and just be one table, so rather than it showing like the above, it should look like this: 

Table: ID - Name

Data: 1234 - Book 

I would also like to add the hypen in there too 

Thank you 

[BrunPierre]

Table1:
LOAD ID

FROM Table1;

Join
Table2:
LOAD Name

FROM Table1;

[New-here1]

Hi Thank you for your comment. 

I don't think I was very clear in my question above (sorry). I have 2 tables but, they are not called table 1 and table 2, I was simply advising that I have 2 tables and what the names of those tables are. So currently, this is what I have

ID 

Name

Those are the table names rather than table 1 and table 2

How does the code change to reflect to this please? Thank you

[BrunPierre · Accepted solution]

ID &'-'& Name as Newfield