Gossamer Forum: General: Databases and SQL: Re: [barryb12000] move data from 1 table to another with PHP: Edit Log

Gossamer Threads

Home : General : Databases and SQL :

General: Databases and SQL: Re: [barryb12000] move data from 1 table to another with PHP: Edit Log

Here is the list of edits for this post

Jul 18, 2002, 2:05 PM

Stealth

Veteran (17240 posts)

Jul 18, 2002, 2:05 PM

Re: [barryb12000] move data from 1 table to another with PHP

You can re-write the query to not use sub-queries like the following:

Quote:

SELECT P.Player_First_Name, P.Player_Last_Name, P.PlayerID
FROM tbl_Players P tbl_Players P2
WHERE (P.PlayerID <> P2.PlayerID)

Just use "table aliases" and the <> or IS NOT operators in the WHERE clause(s).

Good luck!
========================================
Buh Bye!

Cheers,
Me

Last edited by:

Stealth: Jul 18, 2002, 2:05 PM

Edit Log:

Post edited by Stealth Post edited by Stealth (Veteran) on Jul 18, 2002, 2:05 PM

Gossamer Threads is a Vancouver-based company with over 28 years experience in web technology. From development to hosting, we partner with leading organizations around the globe and help to build their web presences, strategies and infrastructures.

Let’s talk: 1-877-715-7676