Question: When I try to list Synthesizer devices in Java (1.6.0), I get only one device, *Java Sound Synthesizer*. I want to use the Synthesizer in the sound card or use any other installed synthesizer, eg. the Microsoft Synthesizer. How can I go about doing that ? If this capability is not inbuilt, is there any open source project that act as front end to synthesizer drivers installed ?

Answer: 
It's almost the same in **MySQL**, but you have to use the **table alias** right after the word "DELETE":

```
DELETE a
FROM TableA AS a
INNER JOIN TableB AS b
ON a.BId = b.BId
WHERE [filter condition]

```
The simpler way is:

```sql
DELETE TableA
FROM TableB
WHERE TableA.ID = TableB.ID

```