I have two tables CREATE TABLE pid_segment ( id INT NOT NULL UNIQUE PRIMARY KEY, msg TEXT) TYPE=INNODB
CREATE TABLE hl7incom( id INT NOT NULL AUTO_INCREMENT UNIQUE PRIMARY KEY REFERENCES pid_segment (id). msg TEXT, time TIMESTAMP NOT NULL) TYPE=INNODB There are few data stored in both tables. Now I will select new messages from hl7incom, where hl7incom.id is not equal pid_segment.id and store this id, msg in pid_segment. With query... SELECT hl7incom.id FROM hl7incom, pid_segment WHERE hl7incom.msg LIKE '%PID%' AND pid_segment.id != hl7incom.id GROUP BY hl7incom.id; ...I get also the id's which are allready in table pid_segment. I tried different querys, also with LeftJoins but couldn't fix the problem. Anybody some idea? --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php