I have two tables : `tracklist(trackid artist event date)` and `radded(trackid, user)` with relation 1 to n (trackid are the keys on each table).

I would like to return the whole tracklist table, by adding a new field called `exist` that should be 1 or 0 if a user (passed trought the query) exist on the radded table for the related trackid for each row.

Example :

**tracklist**

```
*trackid artist event date*
123      art1   eve1  date1
321      art2   eve2  date2
456      art3   eve3  date3
298      art4   eve4  date4
565      art5   eve5  date5

```

**radded**

```
trackid user
123     luigi
123     mario
321     luigi
298     mario
298     antonio

```

if i use the *luigi* as user, the output must be :

```
123 art1 eve1 date1 1
321 art2 eve2 date2 1
456 art3 eve3 date3 0
298 art4 eve4 date4 0
565 art5 eve5 date5 0

```

How can I do this query?