I want to list producers information who produce CD of a particular artist released in a particular year.

My attempt: 

```
$sql="SELECT * FROM producer, cd WHERE name = name and year= year JOIN SELECT * FROM cd, song WHERE  artist = '$_POST[artist]' AND cd.title ='$_POST[title]'"; 
$data=mysqli_query($sql); 
while ( $row = mysqli_fetch_array($data)) {
print_r($row); 

```

Here's the error I'm getting: 

> 
> Error: You have an error in your SQL syntax; check the manual that corresponds
>  to your MySQL server version for the right syntax to use near 
>  'JOIN SELECT \* FROM cd, song WHERE artist = '' AND cd.title =''' at line 1
> 
> 
> 

How am I joining the two queries incorrectly?