I need help to make queries via SQL ; I have two tables, one of products and the other output of products, here the code
Select
saiprod_codproduto,
saiprod_quantidade,
saiprod_valorproduto,
saiprod_valor...
I have a page created in php with mysql database engine and I have 2 tables which I consult to extract a text file delimited by a comma with php.
This is the query:
$registros=$base->prepare("SELECT * FROM datos_solicitudes INNER JOIN en...
What happens is that I need to do something like:
IF Tabla1.GrupoId3 IS NOT NULL
UPDATE Tabla1 SET GrupoAnexado = 'x' WHERE MiCampo = 'Condiciones'
ELSE
UPDATE Tabla1 SET GrupoId3 = 'x' WHERE MiCampo = 'Condiciones'
But it marks me the foll...
In what I find myself validating my chat, I came up with a form that I do not know if it will work yet but it is as follows:
In the chat at the moment to save two data = $ id_user which is the current session and $ id_ar which is the data of...
Hi, I'm working with SQL 14, and I want to join two columns one is Date and the Other Time, I've tried several ways but none of them I'm concerned, I mean they work or join the columns but when I do a query I do not know The change is reflected....
Well I mean, I have a database in SQL SERVER called SIELAB and another database in PostgreSQL called reservations , I managed to make the connection correctly and I have already managed to execute a SELECT query from a stored procedure...
I need to count the number of spreadsheets in a range in table A , and I require that only count the number of spreadsheets that are TIPO CORRECTIVO , which is find in table B , I have the following query but I get a r...
I have a Complex type called GraficaLD that has two properties, an int property called Data and another string property called Label, which I try to do is return a list "List" by executing a query with LINQ
This is my SQL query:
select su...
Good afternoon
I have a problem with Mysql, I need the query to the invoice table that I'm doing, show me the name of the IDs of the foreign keys that I have represented, for example:
INVOICE TABLE
IdFactura
1
IdPersona
6...