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: 
Was trying to do this with an access database and found I needed to use **a.\*** right after the delete.

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

```
In SQLite, the only thing that work is something similar to beauXjames' answer. 

It seems to come down to this 
 `DELETE FROM table1 WHERE table1.col1 IN (SOME TEMPORARY TABLE);`
and that some temporary table can be crated by SELECT and JOIN your two table which you can filter this temporary table based on the condition that you want to delete the records in Table1.