Re: Creating a trigger to search in another table...

[Rene van Geijn]

Rick,

This should work.

DELIMITER $$
CREATE TRIGGER trg_DATATABLE
BEFORE INSERT ON DATATABLE
FOR EACH ROW
BEGIN
SELECT Title
INTO NEW.Title
FROM GRIDTABLE
WHERE V1Low <= NEW.V1
AND V1High > NEW.V1
AND V2Low <= NEW.V2
AND V2High > NEW.V2
END;
$$

See: http://dev.mysql.com/doc/refman/5.0/en/using-triggers.html