I have 3 Tables
Vehicles
idVeiculo | Placa | Prefixo
oleomotor
idMotor | idVeiculo | datatroca | kmtroca | horimetroca | proximatroca |idMecanico
I have this query below that shows the result of the last changes of each vehicle...
How to correctly subtract these two columns in the SQL script?
SELECT DISTINCT b.prefixo as idVeiculo,
max(datatroca) as datatroca,
max(kmtroca) as kmtroca,
max(horimetroca) as horimetroca,...
Question: I have 2 Select Menu and I need the second select to change with data group according to the choice of the first one. Like for example car brand and models. In the first select the marks and in the second the models.
Testing: I have...
Good evening guys, I have a problem here.
I'm trying to upload an MVC + SQL Web application in Azure.
Deploy works fine, Application is in the air.
However, any connection to the bank fails.
At the time of deploy, VS provides the option to creat...
How do I query the following sql query in Mongo?
select * from myDB WHERE nm_pesquisa LIKE "%SAO%" AND tp_m = "A" OR tp_m = "H";
I tried the following but unsuccessfully:
$query = [
'nm_pesquisa' => ['$regex' => MDB::Regex($nm)]...
Two tables tab_Ord_Ser and tab_Pos_Alb .
In two different queries I can know the values but I can not unite them in just one.
These are:
SELECT
Prazo_Producao as Data,
COUNT( 'Numero OS' ) AS Produzir,
Tipo_Album
FRO...