I have two tables:

```
vote('id', 'question_id', 'ip_id')

```

and

```
ip('id','ip_addr')

```

I want to do something like this:

```
INSERT INTO SELECT `vote`.`question_id`, `ip`.`ip_addr` 
            FROM `vote` 
            LEFT JOIN `ip` 
            ON `vote`.`ip_id` = `ip`.`id` VALUES '2','127.0.0.1'

```

the above code is not working, any idea?