Filter data with INNER JOIN - MYSQL

Question

Filter data with INNER JOIN - MYSQL

Navigation

#1 by (0 votes)
#2 by (0 votes)
#3 by (0 votes)

0

Good afternoon, I'm new to the group and wanted to know where I'm going wrong ...

I have a search on the database as well

**

SELECT * FROM Users INNER JOIN naturezanegocio ON Users.emaillogin = naturezanegocio.emaillogin
AND Users.paisorigem = '1'
AND Users.cidade = 'são paulo'
AND Users.estado = 'SP'
AND Users.numfuncionario > '0' < '10'
AND Users.registro = 'sim'
AND Users.investimento = 'sim'
AND Users.interesseparceria = 'sim'
AND Users.niveis_acesso_id = '0'
AND naturezanegocio.natureza IN ('2', '0', '0')
INNER JOIN tecnologia ON tecnologia.tecnologia IN ('5', '0', '0')

**

I need to return only the user who has all these requests, but it does not filter everything at once, but table by table that ends up returning me invalid users for not meeting all requirements ...

Where did I go wrong?

php mysql busca filtro

asked by anonymous 07.06.2018 / 18:13

3 answers

Copy HTML elements into a form Mark critical point on the surface - Matlab

score 0 · Answer 1

Apparently it's a syntax error

Correct syntax:

SELECT column_name(s)
FROM table1
INNER JOIN table2 ON table1.column_name = table2.column_name;

SOURCE: www.w3schools.com/sql/sql_join_inner

score 0 · Answer 2

Try this, I think it will help you

SELECT 
    *
FROM
    Users
        INNER JOIN
    naturezanegocio ON Users.emaillogin = naturezanegocio.emaillogin
        INNER JOIN
    tecnologia ON tecnologia.tecnologia = (Algum Identificador que Possua na tabela Users para fazer referencia)
WHERE
            Users.paisorigem = '1'
        AND Users.cidade = 'são paulo'
        AND Users.estado = 'SP'
        AND Users.numfuncionario > '0' < '10'
        AND Users.registro = 'sim'
        AND Users.investimento = 'sim'
        AND Users.interesseparceria = 'sim'
        AND Users.niveis_acesso_id = '0'
        AND naturezanegocio.natureza IN ('2' , '0', '0')
        and tecnologia.tecnologia IN ('5', '0', '0')

score 0 · Answer 3

Solution

SELECT 
    *
FROM
    Users
        INNER JOIN
    naturezanegocio ON Users.emaillogin = naturezanegocio.emaillogin
        INNER JOIN
    tecnologia ON tecnologia.emaillogin = Users.emaillogin
WHERE
            Users.paisorigem = '1'
        AND Users.cidade = 'são paulo'
        AND Users.estado = 'SP'
        AND Users.numfuncionario > '0' < '10'
        AND Users.registro = 'sim'
        AND Users.investimento = 'sim'
        AND Users.interesseparceria = 'sim'
        AND Users.niveis_acesso_id = '0'
        AND naturezanegocio.natureza IN ('2' , '5', '0')
        and tecnologia.tecnologia IN ('5', '6', '0')
        group by Users.emaillogin