I have 2 tables table1 and table2:

* table1 contains a field named `id` with a value `1212` (example) in it.
* table2 has a field named `action` with a data like `added 1212` or `updated 1212`.

Now check this query.

```
SELECT t1.*, t2.name
FROM table1 t1, table2 t2
WHERE t2.action LIKE 'added t1.id'

```

I want to add the `name` field in the second table, to first one with the `added`(`updated` not needed) data only.
What is the where clause for this condition?
How can I query this?