Posts by Marcelo C. França • 79 points
6 posts
-
1
votes1
answer74
viewsQ: Query to not repeat an already registered value
I have the following situation: I need to make an SQL query in a field to return only the vehicles that are registered in a form (table vehicles) and that the form despachos_ocorrencias the vehicles…
-
1
votes1
answer110
viewsQ: Query with 3 conditions AND does not work the last condition
I would like to make a query in two tables that takes into account 3 criteria, but is not presenting the expected result. Select viaturas.vtr_numero From viaturas, despacho_ocorrencias Where…
-
1
votes2
answers59
viewsQ: Query to add fields from two tables
I need a query where I will need to add people by color and race, distinctly, for example, make the sum not only by name, but also by color and race alike. I tried something below, but it’s adding…
-
2
votes1
answer64
viewsQ: Query SQL summing fields from one table with criteria from another
I would like to do a query that adds for example the name of the equals by date (here I will put the period, for example 01/03 to 22/03), the problem that I have two tables, one of individuals where…
-
2
votes1
answer1577
viewsQ: Open android app via php
I have a web system and would like to call/open an android app installed on a tablet through a button on my system. It is possible via php, javascript or html? Thank you,
-
-1
votes1
answer201
viewsQ: Make a select with 3 tables and return in table 3 the id records of the first
I have three tables, the first is occurrence, the second is to individuals and third vehicles. The individual tables and vehicles I made occurrences subformularios. I have the first key in the…