I am trying to create a trigger that checks one table every time it's updated for a value in one of the fields, if that value is a one, it then needs to delete an entry in another table where both tables job_id matches.
Does anybody have an idea what this might look like? It's been a long week and my eyes, and brain are fried... any help would be greatly appreciated. Thanks, Bill K. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
