On Thu, 2002-11-07 at 16:17, [EMAIL PROTECTED] wrote: > Hi, > > I have the following SQL query, that returns the correct records on Access, > but when I use it with MySQL, it returns duplicate records, and it skips the > required records. > > SearchSQL=select > MarketData.CustID,Contacts.ContactID,Contacts.CustID,MarketData.Nickname,Marke > > tData.Occupation,MarketData.Country > ,County,MarketData.Forename,MarketData.Surname,MarketData.Email FROM > MarketData INNER JOIN Contacts on MarketData.CustID=Contacts.ContactID WHERE > Contacts.CustID=6115
I personally would try: SearchSQL=select MarketData.CustID,Contacts.ContactID,Contacts.CustID,MarketData.Nickname, MarketData.Occupation,MarketData.Country,County,MarketData.Forename, MarketData.Surname,MarketData.Email FROM MarketData INNER JOIN Contacts WHERE MarketData.CustID=Contacts.ContactID AND Contacts.CustID=6115 John Coder --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php