Most voted "inner-join" questions
58 questions
Sort by count of
-
-1
votes1
answer224
viewsMerge two tables with PHP and recover the data in the same html select element
I’m trying to list in the same element select of html the results of the consultation of different tables, but I’m not getting. Follow down the code so someone can tell me where I’m going wrong.…
-
-1
votes1
answer81
viewsCOUNT + JOIN WITH DIFFICULTY IN RESULT
I need to get two results... I have a table with a total of 102 drivers and another table with the date he left to make deliveries and another with the arrival date... I need to know which drivers…
-
-1
votes1
answer64
viewsSQL - search data from different tables without relationship with Ids
Personal table (id, cnae, cnpj, ...) (amount of records 40M) Table cnae_secundario (id, cnae, cnpj) has no attachment by id with the personal table. (amount of 50M records) The user will inform the…
-
-2
votes1
answer31
viewsTables of MYSQL
As the image shows, I have the table adms_unidade where I can already show the units listed, and I have the table adms_equipamentos with various registered equipment. I want to show how many…
-
-2
votes2
answers95
viewsProblem in SELECT INNER JOIN. Appearing ID instead of name
Hello. I would like a SELECT INNER JOIN result to show the record name instead of the record ID. I have researched several topics dealing with the subject here, but I cannot solve this problem. I…
-
-2
votes1
answer308
viewsInner Join php to search in two tables
I need to search with PHP for the data typed in two Mysql tables, produtos and usuario. I’m doing like this: $array = array(); $query = mysqli_query($conn,"SELECT * FROM produtos inner JOIN usuario…
-
-2
votes1
answer62
viewsDatabase - Mysql - Relationship between tables / INNER, LEFT, RIGHT JOIN
I am making a database using the Mysql Workbench and I am in need of a brief assistance. I have six entities in total. tb_people who are related to two other tb_clients and tb_adm entities (because…
-
-2
votes0
answers34
viewsSelect two tables at once
I got the city and neighborhood tables How do I display the city and neighborhood it belongs to ? tried to use a INNER JOIN but it didn’t work ? in that inner join has a $_GET that should fetch the…