join problem in mysql

[kumarboston]

Hello All,

I have 2 tables
a) main: has 2 columns- id and name.
b) alias: has 2 column -id and alternate name.
both the tables are joined through id, now what I am trying to do is if user enters either the name or the alternate name , it should return me the id and the name.

When I tried to use 'OR' as the operator, it returned me all the entries of the database.

Kindly anyone suggest the possible solutions.

Thanks
Kumar

[psicopunx]

Dear Kumar,

Please, post your query.

[r035198x]

Hello All,

I have 2 tables
a) main: has 2 columns- id and name.
b) alias: has 2 column -id and alternate name.
both the tables are joined through id, now what I am trying to do is if user enters either the name or the alternate name , it should return me the id and the name.

When I tried to use 'OR' as the operator, it returned me all the entries of the database.

Kindly anyone suggest the possible solutions.

Thanks
Kumar

Did you try
[CODE=mysql]select n.id, n.name from name n join alias a on n.id = a.id
where n.name = "givenName" or a.alternateName = "givenName"[/CODE]

[Atli]

Hi.

Or even:
[code=mysql]
SELECT n.ID, n.Name
FROM tblName as n
INNER JOIN tblAlt as a
ON n.ID = a.ID
WHERE 'searchTerm' IN (n.Name, a.Name)
[/code]