This is my inquiry code
SELECT
FACTURA."ID" AS FACTURA_ID,
FACTURA."CLIENTEID" AS FACTURA_CLIENTEID,
FACTURA."USUARIOID" AS FACTURA_USUARIOID,
FACTURA."FECHA" AS FACTURA_FECHA,
FACTURA."TOTAL" AS FACTURA_TOTAL,...
I have a relationship between 2 Orders and Users tables from the field user_id and id respectively.
I make this query:
$dql="SELECT u, o
FROM BackendBundle:Orders o
JOIN o.users u";
$query=$em->createQuery($dql)...
Good afternoon, I have a tabla that has clave , clave_padre , anio and nivel , and on the other hand I have a tabla2 that has the clave , cargo , abono , mes and anio .
Wha...
Good morning,
I have this select:
select
count(ob.obj_id) as appeareances,
cl.id as classs,
cl.intl_id as class_intl,
cl.name as class_name,
cf.name as classif_name,
cf.intl_id as classif_intl,
cf.id as classif...
I'm trying to do a JOIN (it's the first time) and I have this code but it shows me the following errors.
Warning: mysqli_query () expects at least 2 parameters, 1 given in C: \ xampp \ htdocs \ inventory \ int.php on line 5
W...
I have 3 tables from which I am trying to collect data by doing LEFT JOINS.
In the contacts table I have 2 types of contacts, people and companies each with their unique id and another associative one.
When I execute the query that I leave...
I have two tables: table A has certain fields, including its primary key Id ; in the development they have table B with a field with which table A is related (conceptually, since there is no relationship created in the database).
In cer...
That such a friend can support me like making a join from a normal table to a pivot table the tables are:
* orders
* products
* OrderPorduct (pivot table)
What I have to do is a join of orders toProduct Order where the id of the order and the...
I have two tables
They have Field1 and Field5 in common, so I tried the following query:
Select Campo1, Campo2, Campo3, Campo4, Campo6
From Tabla1 T1
Inner join Tabla2 T2
On (T1.Campo1 = T2.Campo5)
hoping to have something like t...