On Monday, September 30, 2002, at 08:44 24h, Gebhardt, Karsten wrote:
> 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; Did you try using '<>' instead of '!=' -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707 Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.com -- --------------------------------------------------------------------- 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