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
Found solution, the right syntax is:
SELECT hl7incom.id
FROM hl7incom, pid_segment
LEFT JOIN pid_segment
ON hl7incom.id = pid_segment.id
WHERE hl7incom.msg LIKE '%PID%'
AND pid_segment.id IS NULL;
Cheers for try of help,
Karsten
Same result, also if I do not define unique index.
Just a sug
Same result, also if I do not define unique index.
Just a suggestion:
SELECT hl7incom.id
FROM hl7incom, pid_segment
WHERE hl7incom.msg LIKE '%PID%'
AND not(pid_segment.id = hl7incom.id)
GROUP BY hl7incom.id;
Otherwise my only other suggestion would involve using the 'NOT IN'
logic, but I think
luted for your needs.
-Original Message-
From: Gebhardt, Karsten [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 01, 2002 12:07 AM
To: '[EMAIL PROTECTED]'
Subject: RE: select problem with "not equal" syntax
No way, I've already tried this.
> I have two tables
No way, I've already tried this.
> 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
On Mon, 2002-09-30 at 23:44, 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,
> tim
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. N
