Inner Join Problem

Question

User197255166 posted

Hi everyone,

I'm making an Inner Join. As an example Solution tablom there is a Solution Category tablom that is bound to it. The following query returns 2 records when the result is 1 record. What is the reason of this.

  select TS.CozumAd from T_SolutionSubCategory TS INNER JOIN 
  T_Solution TL on TS.SolID = TL.ID

Answer 1

User-82109136 posted

I think you forgot the query

Answer 2

User197255166 posted

Thank you.. I shared my code.

Answer 3

User1120430333 posted

Thank you.. I shared my code.

So you  did an inner join. So what's the problem, since you are giving no explanation about any thing and you picture doesn't work?

Answer 4

User1724605321 posted

Hi Aliyillmaz,

What is the your expected result  ? And here are some tips about SQL join :

Best Regards,

Nan Yu

Answer 5

User197255166 posted

there are two results here. I need only one result.

Answer 6

User1724605321 posted

Hi Aliyilmaz,

There will be two results as you can find the TS.SolID(1,2) equal TL.ID(1,2) , can you clearly  which record  is the expected one and what is the condition .

Best Regards,

Nan Yu

Answer 7

User197255166 posted

Hi,

in fact I want to do is come up with 1 on a fixed page. How can I do that. I am using entity framework and linq to sql.

Answer 8

User1724605321 posted

Hi Aliyilmaz ,

For example :

from s in db.T_SolutionSubCategory
join sa in db.T_Solution on s.SolID equals sa.ID
where s.ID == 1
select s

Where db is your DbContext .

Best Regards,

Nan Yu

Answer 9

User-2054057000 posted

The query returns correct result. See the on keyword where you have applied the conditions. 2 records matches so you get 2 records as output.