List:General Discussion« Previous MessageNext Message »
From:Victor Pendleton Date:August 17 2004 6:15pm
Subject:RE: Assistance with SQL syntax: pulling duplicates back
View as plain text  
You have a cartesian join because you do not have join criteria between the
resume and candidate tables. 

-----Original Message-----
From: Eve Atley
To: mysql@stripped
Sent: 8/17/04 12:22 PM
Subject: Assistance with SQL syntax: pulling duplicates back


I think this is an easy question...I've set up a SQL statement like so:

SELECT resume.Section_Value, candidate.Location FROM resume, candidate
WHERE
resume.Section_ID = '1' AND MATCH (resume.Section_Value) AGAINST
('html')
AND candidate.Location LIKE '%CA%' OR 'California'

------------------
And where 'html' should come up in 1 entry, I get duplicates when
printing
out the field to the screen:

------------------
html unix network php Over 10 years of HTML experience. 2 years
networking
administration.

html unix network php Over 10 years of HTML experience. 2 years
networking
administration.

------------------

I can't decide if this is my code, or the SQL syntax. Would it be
possible,
based on this statement, to have pulled back duplicates from the same
record?



- Eve



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
Thread
GUI for MySQLKirti S. Bajwa12 Aug
  • AW: GUI for MySQLFreddie Sorensen12 Aug
  • Re: GUI for MySQLKaram Chand13 Aug
  • Re: GUI for MySQLMartijn Tonies13 Aug
    • Full text for keyword(s) search?Eve Atley17 Aug
RE: GUI for MySQLGuillermo Chinchilla Zúñiga12 Aug
RE: Full text for keyword(s) search?Victor Pendleton17 Aug
  • Assistance with SQL syntax: pulling duplicates backEve Atley17 Aug
    • Re: Assistance with SQL syntax: pulling duplicates backMichael Stassen17 Aug
      • Re: Assistance with SQL syntax: pulling duplicates backMichael Stassen17 Aug
    • Re: Assistance with SQL syntax: pulling duplicates backSGreen17 Aug
RE: Assistance with SQL syntax: pulling duplicates backVictor Pendleton17 Aug
Re: Assistance with SQL syntax: pulling duplicates backMichael Stassen17 Aug