Hello everybody,
I have a next problem to get a query working.
I have some tables. A User has Phone numbers and Calls associated with
each phone.
# Example: All the calls of the user number 1
SELECT
Call.*
FROM
User, Phone, Call
WHERE
Phone.User=1 AND
Call.Phone=P
> Hi,
>
> select table1.col_name FROM table1 left join table2
> on table1.col_name = table2.colnmae where table2.clnmae is null
>
> Rich
> Inbal Ovadia wrote:
>
>> Hi
>> i want to do in mysql query like that:
>>
>> SELECT col_name FROM table1 NOT IN (select col_nmae FROM tablse2)
>>
>> how can i
PROTECTED]
Subject: in and not in
Hi
i want to do in mysql query like that:
SELECT col_name FROM table1 NOT IN (select col_nmae FROM tablse2)
how can i do that?
thanks
-
Before posting, please check:
http://www.mysql.com
May 22, 2002 10:59 AM
Subject: in and not in
> Hi
> i want to do in mysql query like that:
>
> SELECT col_name FROM table1 NOT IN (select col_nmae FROM tablse2)
>
> how can i do that?
> thanks
>
>
>
>
Hi
i want to do in mysql query like that:
SELECT col_name FROM table1 NOT IN (select col_nmae FROM tablse2)
how can i do that?
thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http:/
NOT IN
I've noticed that MySQL doesn't support the use of internal selects with the
in and not in methods such as in this example from a where statement.
and shift_id not in
(select shift_assoc from facdba.staff_schedule_temp
where status <&
I've noticed that MySQL doesn't support the use of internal selects with the
in and not in methods such as in this example from a where statement.
and shift_id not in
(select shift_assoc from facdba.staff_schedule_temp
where status <&
