don't get this one:
from mysql.com:
SELECT s1 FROM t1 WHERE s1 NOT IN (SELECT s1 FROM t2);
my query:
select trans_no from orders where trans_no not in (select trans_no from
special_orders);
and I'm getting an error:
You have an error in your SQL syntax. Check the manual that corresponds
to your MySQL server version for the right syntax to use near 'select
trans_to from printed_orders)' at line 1
Syntax error?
???
-afan
[EMAIL PROTECTED] wrote:
I tried this one:
SELECT trans_no
FROM orders
WHERE trans_no IN (
SELECT trans_no
FROM special_orders )
but gives me an error:
You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'SELECT trans_no FROM special_orders )' at line 5
???
Philip Hallstrom wrote:
I apology for mysql question posted here, but, as I said once, I
like you guys more! :)
have two tables: orders and special_orders. foreign key is trans_no.
I can't figure it out how to create a query that pulls orders from
the "orders" tables that are NOT in "special_orders" table?
I can never remember the syntax, but you want to LEFT JOIN the tables
and then only return rows where the resulting special_orders column
is NULL.
something like this (most likely wrong syntax):
SELECT o.trans_no, s.trans_no FROM orders o LEFT JOIN special_orders
s ON o.trans_no = s.trans_no WHERE s.trans_no IS NULL
But that should get you started...
-philip
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
