Write sql query

Question

I have a table that contains the below data enter image description here

I want to write a query that display the below data enter image description here

What have you tried? Please add to your question your code so far, even if it is broken. Is there a particular part that is confusing you? — Merlyn Morgan-Graham
– Merlyn Morgan-Graham, Commented Dec 10, 2011 at 17:10

Udo Held · Accepted Answer · 2011-12-10 17:19:52Z

3

Use a self join:

SELECT eng.id, eng.description english,
  fre.description 
FROM label eng JOIN label fre ON eng.id = fre.id
WHERE eng.languageId = 1 and fre.languageId= 2

As you didn't give a table name I choose label replace it with your real table name.

edited Dec 10, 2011 at 17:19

answered Dec 10, 2011 at 17:06

Udo Held

12.6k11 gold badges73 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

marc_s Over a year ago

I would prefer to use proper ANSI JOINs : FROM label eng INNER JOIN label fre ON eng.id = fre.id WHERE eng.languageId = 1 and fre.languageId = 2 - these are both cleaner, and that's the ANSI standard

Collectives™ on Stack Overflow

Write sql query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related