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: 
```
DELETE TableA
FROM   TableA a
       INNER JOIN TableB b
               ON b.Bid = a.Bid
                  AND [my filter condition] 

```

should work
I would use this syntax

```
Delete a 
from TableA a
Inner Join TableB b
on  a.BId = b.BId
WHERE [filter condition]

```