Questions tagged as 'join'

Tagged questions
1
answer

Pass a lambda statement per parameter - C # - Entity

I have a method in which I need to pass only one select per parameter: public List<TEntity> GetAll(Expression<Func<TEntity, TEntity>> Select) { var query = Context.Set<TEntity>() .Where()...
asked by 07.11.2016 / 23:52
1
answer

INNER JOIN Performance in SQL

Hello, could anyone tell me if there is any significant performance difference in the two ways of doing INNER JOIN below? Way 1: SELECT column_name(s) FROM table1 INNER JOIN table2 ON table1.column_name=table2.column_name; Way 2: SELEC...
asked by 17.12.2015 / 19:42
1
answer

LEFT Outer Join does not work in LINQ when 0 is the reference? only null

I'm having doubts on Left Outer Join, I'm using MVC 5 C #, Net 4.5.2. I have the Next Model Supplier public class fechamentoFornecedor { public int FornecedorId { get; set; } public int Tipo { get; set; } publ...
asked by 26.02.2016 / 15:09
1
answer

Display foreign keys from a table in the query

I have a table where every projeto can be related to up to 4 produtos . Main table (foreign keys): IDPRODUTO IDPRODUTO2 IDPRODUTO3 IDPRODUTO4 Table produtos ID N...
asked by 15.04.2015 / 00:36
2
answers

Query Mysql does not return error or result

I have 5 tables in which each of them has data that needs to be displayed grouped by date. Proposals are grouped by date, quantity of proposals, value of proposals, media, amount invested, number of clicks, code (source_code) and if it is denied...
asked by 30.04.2014 / 20:28
1
answer

Generate a table from other 5

I need help to build a query that brings data from 5 other tables. I will try to be as clear as possible, if information is missing, please let me know. Come on: I have the Media table: link and the Proposals table: link The othe...
asked by 02.05.2014 / 15:43
1
answer

Crystal Report with LEFT JOIN and WHERE

I have a problem making a LEFT JOIN in Crystal Reports. From what I've researched, it's a classic SQL problem when using WHERE criteria by crossing LEFT JOIN . I tried to solve it anyway, but I could not. There are 4 related tables: [Orc...
asked by 04.12.2014 / 18:43
1
answer

Join tables

I have three tables one call CRM_PROCESSO , another call CRM_PROCESSO_VARIAVEL and last call CRM_PROCESSO_ATIVIDADE , both have the variable idprocesso in common. What I need is for the command to bring the field...
asked by 21.09.2018 / 15:45
2
answers

Difficulty in returning the result in a query without duplicating

I am trying to set up a query (MYSQL) to return all the clients that a particular vendor can view. The rules for showing the list of customers for this seller are: - Clients with overdue contracts or without contracts. - Customers with bids or n...
asked by 24.10.2017 / 15:17
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