Problems with basic Join

[anders2002]

Can anyone help me with this query:

SELECT company.companyName, myaccounts.activelead FROM company,myaccounts where (company.companyName like "%cousins%&quot or (myaccounts.accountName like "%cousins%&quot
ORDER BY company.companyName Asc

There will always be a companyName stored in I would like it to return from the LIKE query, but not always one in the activelead table.

At the moment, if there is no entry like "cousins" in the myaccounts table, i get no returned results even though there are matching entries in companyName.

Can anyone help me?

 

[nigelcohen]

Anders

You are selecting records from two tables, without giving a statement about how to link the two tables.

Try something like this ( I am guessing which fields link the two tables):

SELECT company.companyName, myaccounts.activelead
FROM company,myaccounts
WHERE

company.Ref = myaccounts.companyRef
and
(

(company.companyName like "%cousins%&quot or (myaccounts.accountName like "%cousins%&quot

)
ORDER BY company.companyName Asc