I have the following sentence:
SELECT
REF
FROM
inv_articulo as a
INNER JOIN inv_tipoarticulo as t ON a.TIPO_ARTICULO = t.PK_TIPO
INNER JOIN inv_categoria as c ON c.PK_CATEGORIA = t.FK_CATEGORIA
WHERE
c.pk_categoria = 7
or...
I'm generating a form where I need to get some value from a Jcombobox
Currently, this is my code:
private void llenarMatriz() {
String cmb = "SELECT DISTINCT nombre_matriz FROM matriz ORDER BY nombre_matriz ASC";
try {
Statem...
I have this relationship diagram, I want to show the names of the teachers and the name of the subjects they taught. I have seen that with some query Join can be done but I have tried several and it throws me an error or shows me only the...
The following is my code and it works to send data from C # to my REST API and this information is stored correctly in the database:
so I send the information from C #:
using (var WC = new WebClient())
{
WC.Headers...
- Hi, it's my first posting, I hope you can understand me clearly. -
I have 5 variables which are of the Bool type. True or False.
I need to be able to generate a SQL statement depends on the states of the variables.
I was able to gen...
I have a question with the confirmation before deleting a record from my Database, for this I am using PHP and the AlertifyJS library, in my HTML structure I have a link through which I send by GET method the id of the person to delete, in this...
I have a sql statement where I want to join update with select but it gives me the following error:
Error Code: 1093. Table 'a' is specified twice, both as a target for 'UPDATE' and as a separate source for data 0.000 sec
My sentence is as...
I have a table created in HTML with PHP and MySQL, and I need that with a input to do a search in real time of that same table, will it be possible?
Here the code:
Body of the page:
<div id="main">
<div id="he...
I need to add the salaries of the next query I have and sort them by description.
select distinct
cp.descripcion,
cp.idSysCPPuestos,
em.sueldoDiario,
em.sueldoIntegrado,
em.idSysCPCentroCosto
--,sum(CAST(em.sueldoDiar...
In my application users logged in through a button register themselves with an activity, when they click on the button, the user and activity information is sent to a table in the database.
The above works in the following way:
Laravel dri...