AIL PROTECTED]>
CEO / Geschäftsleitung iConnect GmbH <http://iConnect.de>
Heesestr. 6, 12169 Berlin (Germany)
Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: "John Chang" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, Nove
I am creating a search form for the TitleName. When I type in one word it
finds all titles with the one word. If I use two words it doesn't work.
How do I change my select statement to make it work? Thank you.
SELECT *
FROM Titles A, ActorTitle B, Actors C
WHERE A.TitleID=B.TitleID AND B.ActorI
Hi,
If I have two MYSQL tables with two columns for email addresses respectively:
csc_teammembers.tes_email AND cscflash_mb.email
Now, what I want to do is query only those email addresses in cscflash_mb that
DO NOT have a match in the csc-teammembers dbtable.
Can I just do a select statement
I am assuming from your email that the field ID allows duplicates. In that
case, use the SELECT DISTINCT syntax ... that will get you back the 1 row
you are looking for. However, if the (ID,CompetitorName) tuple is unique,
SELECT DISTINCT will NOT help.
Hope this helps
Raj
At 06:12 PM 9/23/200
As I am still a newbie to mysql I am sure that some of the problems that I
am coming accross are created by myself, and others are probably so simple
that they are staring me in the face. I do, however, seem to be having some
problems with the below statement.
I would like the result of the que
