delete ...

Question:
How would I write a SQL statement to delete rows from tables based upon matching values between 2 tables ?

Gabbar:
DELETE t1
FROM
tblTable1 t1
INNER JOIN tblTable2 t2 ON
(t1.fldID = t2.fldID
AND t1.fldField5 = t2.fldField5)
WHERE
t2.fldField6 = @Value