Gopalarathnam V. wrote:
Your sub-select query can be written as:
select t1id from t1 left join t2 on t1id = t2id where t2id is null
in MySQL.
Too restrictive -- the original poster, Phil Dowson, wanted to find all
t1 rows except those that have t2.t2gid = 194 (or some other t2gid value).
The a
Hi Alec-
Your sub-select query can be written as:
select t1id from t1 left join t2 on t1id = t2id where t2id is null
in MySQL.
The example is actually given in the MySQL manual itself (section 1.7.4.1).
[EMAIL PROTECTED] wrote:
I am trying to check a table to see if a value doesnt exist, and
Phil Dowson wrote:
Literally in MSSQL server you would have (but I cant use subselects)
SELECT t1id FROM t1 WHERE t1id NOT IN (SELECT t2id FROM t2 WHERE t2gid = 192)
SELECT t1id FROM t1 left join t2 ON t1.t1id =t2. t2id AND
t2.t2gid = 192 WHERE t2.t2id IS NULL
--
Quoting Bruce Feist <[EMAIL PROTECTED]>:
> Phil Dowson wrote:
>
> >SELECT t1.t1id
> >FROM t1
> >LEFT JOIN t2 ON t1.t1id = t2.t2id
> >WHERE t2.t2gid <> 192 //an example of a gid I am using//
> >
> >This is close, it shows all the id's that exist in the t2 table without a
> >t2.t2gid of 192, bu
Quoting Bruce Feist <[EMAIL PROTECTED]>:
> Phil Dowson wrote:
>
> >>Looks like a syntax error to me. There is no t1id in t2. Also, the OR
> >>is redundant; if no t2 row was found, both t2id and t2gid will be NULL,
> >>so checking one of them suffices. Try
> >>
> >>SELECT t1.t1id
> >> FROM t
> I am trying to check a table to see if a value doesnt exist, and I
> would prefer to use the NOT IN syntax, but that doesnt work for mysql.
> I've been trying to construct a similar statement in MySQL, but I'm
> coming up cold.
>
> t1
> 't1id'
> '1'
> '18'
> '19'
>
> t2
> 't2id','t2gid'
> '19',
Hi All,
I am new to this list, so appologies if I sound like a newbie.
I am trying to check a table to see if a value doesnt exist, and I
would prefer to use the NOT IN syntax, but that doesnt work for mysql.
I've been trying to construct a similar statement in MySQL, but I'm
coming up cold.
t1
