Pieter

great thx...you helped me out a lot!

yup that's what i want...text1 and text2 have the same label but are in a different row,I want a result so i can get the label and text1 and text2 in the same row in differenct columns.

then could i just make a new table out of it? in stead of making a select?

I have this table called tblTextIt has 4 columns:- text_ID- language_ID- label- texttext_ID = Unique number (prim key)language_ID = 1 or 2 or ... (1 = Dutch, 2 = English)label = label to where the text points (ex. lblTitle)text = de text that will be placed in the label (ex. Hello or Hallo or ...)example of 2 records: text_ID | lang_ID | lable | text |1 | 1 | lbltitel | Hallo |2 | 2 | lbltitel | Hello | Now i would like, using SQL get the following structure: lable | text1 | text2 example: lbltitle | Hallo | Hello Is this possible?It's not necessary that I actually create a new table, creating a select like this: select label,tekst1,tekst2 from tblText would be actually better.I'm using SQL in VB.NET 2005 with ASP.NET and C#many thanks in advance!