Uh, I don't have anything to add to this thread except that this was
the *exact* problem I was trying to solve and this really helped me a
lot. Thanks guys.
-BL
On 5/22/06, Jay Pipes <[EMAIL PROTECTED]> wrote:
Yesmin Patwary wrote:
> Hi,
>
> Greatly appreciated your kind help. Would it wor
T * FROM t3;
++
| id |
++
| 3 |
| 5 |
| 7 |
| 9 |
| 11 |
++
5 rows in set (0.00 sec)
Hope this answers your questions!
Cheers,
-jay
Jay Pipes <[EMAIL PROTECTED]> wrote:
Yesmin Patwary wrote:
Dear All,
Need to find ids that are NOT in other two tables. With the help of
cu
ON c.company_id = cu.company_id
WHERE p.company_id IS NULL
AND cu.company_id IS NULL;
I am not sure if this join query will remove records from other tables.
Jay Pipes <[EMAIL PROTECTED]> wrote:
Yesmin Patwary wrote:
> Dear All,
>
> Need to find ids that are NOT in ot
Yesmin Patwary wrote:
Dear All,
Need to find ids that are NOT in other two tables. With the help of PHP scripting and three queries I am able to do the task. Can this be done with one mysql query?
Below are current quires:
SELECT DISTINCT company_id FROM company_db
SELECT
Dear All,
Need to find ids that are NOT in other two tables. With the help of PHP
scripting and three queries I am able to do the task. Can this be done with
one mysql query?
Below are current quires:
SELECT DISTINCT company_id FROM company_db
SELECT company_id FROM
