Best answeres tagged with inner

2

answers

Count friends in common using LEFT JOIN

asked by 03.05.2016 / 18:05

2

answers

How to make an INNER JOIN does not repeat information

I have the following SQL INNER JOIN : $sqlxml = " SELECT clientes.id, clientes.nome, clientes.status, clientes.cliente, clientes.tipo, clientes.disponibilidade, imoveis.id, imoveis.cod, imoveis.status, imoveis.vanual, COUNT(imoveis.id) AS im...

asked by 14.03.2016 / 17:51

2

answers

Delete cascading table data

I have some relationships in my tables and I'm wanting to delete them in reverse. In my system the user will have the option of deleting a category, here comes my doubt as I will do this, because it should delete the pages, category descript...

asked by 13.06.2015 / 20:35

2

answers

Doubt about using the inner join

I have 4 tables in my database Tabela Cadastro - idCadastro(PK) - IP Tabela Porta - idPorta(PK) - numero porta - idSwitch(FK) Tabela Porta_has_Cadastro - idCadastro(FK) - idPorta(PK) //Observação: Relaçao...

asked by 23.10.2015 / 13:51

3

answers

Relationship between tables

I have the following tables: TB_ESTOQUE |COD_PRODUTO|QT_DISPONIVEL|COD_FILIAL| | 0856322 | 5 | 41 | | 0856351 | 2 | 41 | | 0856322 | 9 | 114 | | 0856720 | 3 | 20 | | 08563...

asked by 09.10.2018 / 16:41

2

answers

Select with INNER JOIN, bringing fields that have foreign key NULL

I have a table of items, request_itens, interested (it has auto relationship, it is used for secretary, sector and employee, and a requested table), in the order table I have 3 foreign keys (one for secretariat, another for sector and one more f...

asked by 27.05.2016 / 23:21

1

answer

Select with Inner join too slow

I have a problem where select is bringing the right result, but it takes too long. Follow the select: SELECT c.cod_paciente, p.nome, i.valor, i.quantidade, d.convenio, c.cod_conta FROM caddadosclinico d INNER...

asked by 05.01.2018 / 20:26

1

answer

Using data from one select within another?

Two tables tbl_orcamento and tbl_itens the table budgets have a column with the following statuses. 1 = orcamento aprovado 2 = ordem de compra emitida 3 = ordem de compra aprovada The tbl_itens has some columns I will l...

asked by 24.04.2018 / 20:35

1

answer

C # WebBrowser How can I get innerHTML from a span inside a div

OI people. I need to get with c # the innerHTML of the first SPAN element that has a numbered value that is inside a div and I I already wrote a code that is on the right track I think .. so far is this: HtmlElementCollecti...

asked by 20.08.2018 / 00:40

1

answer

MYSQL - Select 2 tables

Good morning everyone! I'm having a problem querying MYSQL, and the query I'm using is not displaying the results you want. Here's the example: TABLE: CLIENTES (codigo_cliente, nome, cnpj) TABLE: HISTORICO_CONTATOS (protocolo, co...

asked by 08.11.2016 / 14:08

Questions tagged as 'inner'