Problem: I have to tables in one DB im trying to compare the ProjectProperties with the UserProperties, if i run this query it will only return my ProjectProperties its probably something very easy im overlooking
.
Thanks in advance!
SELECT projects.ProjectProperty1, projects.ProjectProperty2, users.UserProperty1, users.UserProperty2
FROM projects, users
WHERE projects.ProjectProperty1 LIKE CONCAT(‘%’, users.UserProperty1, ‘%’) OR projects.ProjectProperty2 LIKE CONCAT(‘%’, users.UserProperty2, ‘%’) OR users.UserProperty1 LIKE CONCAT(‘%’, projects.ProjectProperty1, ‘%’) OR users.UserProperty2 LIKE CONCAT(‘%’, projects.ProjectProperty2, ‘%’),