Questions tagged as 'subconsultas'

I'm doing a sql database on foods. The tables I have are meals from the sierra jungle coast and ingredients. And its intermediate tables. What I want to do is a query that allows me to obtain a meal by entering several ingredients in the where....

I am trying to make a subquery (in a particular column) within the base query. The code is as follows. select z.po_id, max(SELECT etcdc.ship_evnt_tms from COVINFOS.SHIPMENT_EVENT etcdc where etcdc.SHIP_EVNT_CD = '9P' and etcdc.ship_id=scdc.sh...

I would like to ask you the following, is it possible to use a variable to filter the information that comes from a query of a DBLINK ?. Something like this: SELECT * FROM ( SELECT * FROM dblink('dbname=db port=5432 host=dbhost user=dbuser pa...

I edit the post with the solution: SUMMARY: What we want is that when searching for the client id, show me the complete record of the client. (Vary the table to taste or need) Code resolution to the problem: <form method="POST" act...

Good morning I'm doing an exercise in which they ask me to make an ABM form and I did it in the following way this would be the file edit.php where is the update button that leads to another page to edit the data and then update them in the i...

Error: Part of the PHP code: //Habiendo conexión, la base de datos puede no existir o ... mysqli_select_db ($conexion, $basedatos) or die ("No se encuentra la base de datos"); mysqli_set_charset ($conexion,"utf-8"); //Haremos una consul...