join

There is a task: A father always has only one son. Sons, in turn, can also be fathers. Requests: (1) get the user together ... it was intended, from which the conclusion is that I am doing something wrong, I could not understand what is wrong myself.

Hello everyone, I ran into a small problem. There are related tables, the data from them I got, but I need to count the recor ... nce the date is in full format, it counts only one record at a time. I need an output of type 2018 | 4. How do I do this?

There are two tables in the first table ID and several other fields, in the other table VALUE_ID and several other fields How ... when filtering by ID, or the fields of the table bx_uf outputs only its fields, the table bx does not join the output values

What is the difference between INNER JOIN and OUTER JOIN? What do they mean?LEFT JOIN, RIGHT JOIN and FULL JOIN? Translation of the question " Difference between INNER and OUTER joins" @cdv.

Let's say there is such a request: SELECT t.type_condition AS pay, t.type_condition AS orders, t.type_condition AS n ... and output the contents in the form of words. And this caused me a difficulty, I can not come up with a working query.

Why doesn't the '\n ' separator work. join (), the list items are output to файл.txt in a row, one by one, without a space. A ... '\n'.join([str(j) for j in rows1]) txt2 = '\n'.join([str(j) for j in rows2]) text1.setText(txt1) text2.setText(txt2)

Hello, I would like to know how to make multiple INSERTs in a table with the result of a SELECT of all the Ids of another tab ... m the other table that are not in the first one, what I want is to type a repeat structure that will execute INSERTs n times.

I have the following tables: Users : id | usuario | pnome | snome | foto 1 | Igor | Igor | Souza | perfil.png 2 | A ... RIMARY KEY (`id`); ALTER TABLE `amizades` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=13; Example image:

I took an example of people registration with the following structure: I am trying to make a SELECT na tblPessoa with JOIN ... company name, the PF has the name and the producer has the name of the Farm / site / Etc. This diagram is an example I took.

I have the SQL below, which returns data that I will fill in some inputs from a form. The problem is that I have 20 items (pi ... P18.COD_PECCIN = O.ITEM_18 AND P19.COD_PECCIN = O.ITEM_19 AND P20.COD_PECCIN = O.ITEM_20

Example : I have two tables: table1 : with two columns product ID, product_name ; table2 : with three columns mar ... JOIN tabela2 m ON p.id_produto = m.id_produto ) I got a nice SQL syntax error. Is there another way to do that ?

Personnel I need help, I need to create a report that shows the total quantity of each product in stock, but I can not make t ... duct name is the STOCK_2 The table structure is: ESTOQUE_1 COD_PRODUTO | QTD_SALDO ESTOQUE_2 COD_PRODUTO | NOME_PRODUTO

For example, I have the tabela_A: cod nome 1 stack 2 overflow 3 stackoverflow And tabela_B: cod ... NULL NULL NULL 3 stackoverflow NULL NULL NULL NULL Is there any way to get this result?

I have a table X that has my user's data, and I need to return to the client the data related to that user in the table Y and ... g JOIN or: SELECT attr1, attr2 FROM Y WHERE X_id = id SELECT attr1, attr2 FROM Z WHERE X_id = id Which is more efficient?

I am doing a section on my website called "My Ideal board", in it the user enters his data(weight, height, etc.), a compariso ... FROM DADOS_USUARIO AS USU INNER JOIN PRANCHA AS PRAN ON(USU.usuario = PRAN.prancha_pri);

I have the following loop in a table from view @foreach ($filme as $f) <tr> <td>{{ $f->fil_id }} ... ut only displays the category id as it is in the movie table. How to give an INNER JOIN with the category table in laravel 5?

I have 2 database tables: Servers +----------+--------------+ | Field | Type | +----------+--------------+ | ... one) from the table stats that has the type equal to online or offline . How could the query be used to make this rule?

I am using pthread.h and using the following functions: // // Cria A thread // thread_argsPP[contthreadsPP] = cont ... closing the thread I can't recreate it, I would like to know if there is any way to reuse a pthread after pthread_exit(NULL).

this question already has answers here : ... plies the difference, and the reason for having the 2 terms, of so the 2 were created, and created by someone. Thank you.

this question already has an answer here : ... ON tbvendas.CodCli = tbclientes.AutoCod I would like to put a WHERE status = "debitado" the column status is in tbvendas