query with two kind of join

[diegomarino]

hi
here there is a db with a query called don't open on design (the name is relevant) in which i select the records in the two tables that have same name and one of the two fields (connected on_1=connesso il OR connected on_2=connesso il_2)

now, i'd like to add another join, the fields "position" and "company" must be different at least for one of them
how can i do that?

thanks

[CJ_London]

think you need to provide some example data to illustrate what you mean

otherwise, why not just use criteria?

[diegomarino]

in the image you can see an example.
the highlited row is the result i want
the "name" is the same, one of the field between "position" or "company" are not the same, and one of the field "connected on_1" or "connected on_2" are the same

[CJ_London]

so like I said use a criteria

SELECT LK_contatti.[Nome cognome], LK_contatti.Position, LK_contatti.Company, LK_contatti.[Connected On_1], LK_contatti.[Connected On_2], [LK contatti_messaggi TOT UNICI LOCALE].[Nome cognome], LK_contatti.Company, [LK contatti_messaggi TOT UNICI LOCALE].Position, [LK contatti_messaggi TOT UNICI LOCALE].Company, [LK contatti_messaggi TOT UNICI LOCALE].[Connesso il], [LK contatti_messaggi TOT UNICI LOCALE].[Connesso Il_2]

FROM LK_contatti INNER JOIN [LK contatti_messaggi TOT UNICI LOCALE] ON LK_contatti.[Nome cognome] = [LK contatti_messaggi TOT UNICI LOCALE].[Nome cognome]

WHERE ((([LK contatti_messaggi TOT UNICI LOCALE].Position)=[LK_contatti]![Position]) AND (([LK contatti_messaggi TOT UNICI LOCALE].Company)<>[LK_contatti]![Company])) OR ((([LK contatti_messaggi TOT UNICI LOCALE].Position)<>[LK_contatti]![Position]) AND (([LK contatti_messaggi TOT UNICI LOCALE].Company)=[LK_contatti]![Company])) OR ((([LK contatti_messaggi TOT UNICI LOCALE].Position)<>[LK_contatti]![Position]) AND (([LK contatti_messaggi TOT UNICI LOCALE].Company)<>[LK_contatti]![Company]))

your example result required does not match the data supplied, so I'm guessing this is what you require

[diegomarino]

it is very nice, just what i needed. I thought only to join, not criteria.

maybe if possible i'd like another criteria, the field "sender profile url": the name OR the sender profile url should match. Is it possible?

[CJ_London]

yes - but your requirement is not clear as to how to implement - if a different query then do much the same thing as per my suggestion but with these other fields. Alternatively if you mean to return these others as well then in the existing query grid, add as new rows in the criteria grid below the existing rows.

[diegomarino]

yes i figured it out thanks.
maybe it's fine this solution, linkedin data are not so good