Pieter
-
Posts
4 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by Pieter
-
-
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.What are you trying to do? What is the relationship between text1 and text2? Are you saying you want to get all text fields that have the same label? -
then could i just make a new table out of it? in stead of making a select?They are seperate records. A Select just Selects 1 record at a time. You can't do that....not anyway I know how. -
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!
SQL Help needed
in SQL
Posted