Creating triggers with joins

I have need to create insert, delete, and update triggers for a table that execute when data in a second related table meets certain conditions. For example, table A and B may look like this: TABLE A Id Name State 1234 Bob MN 2233 John FL Table B Id Car_Color 1234 Blue 2233 Red Is it possible to create triggers in Table A that update, delete, or insert a row, only when the car color for that same person Id is Blue (the associated row in table B has Blue in the Car_Color column). -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own