Query Help
-
Hi I have result set as table name=ID ID1 ID2 ID3 1 3 1 2 6 1 1 1 1 I want output as Name1 Name2 Name3 A C A B D A A A A I have one table for name is Name field of this table are:Id,Name. I m trying query as Select Name.Name as Name1 Name ,Name.Name as Name2 from Name,Name.Name as Name3 from Name inner join ID on Name.ID=ID1 Inner join ID on Name.ID=ID2 inner join ID on Name.ID=ID3 above query is giving error. Plz help in this thanx Care Carrer
-
Hi I have result set as table name=ID ID1 ID2 ID3 1 3 1 2 6 1 1 1 1 I want output as Name1 Name2 Name3 A C A B D A A A A I have one table for name is Name field of this table are:Id,Name. I m trying query as Select Name.Name as Name1 Name ,Name.Name as Name2 from Name,Name.Name as Name3 from Name inner join ID on Name.ID=ID1 Inner join ID on Name.ID=ID2 inner join ID on Name.ID=ID3 above query is giving error. Plz help in this thanx Care Carrer
Man thats ugly, got to be one on the lousiest data structures around. Joins are not going to do it. You will need to use sub selects.
select (Select name from name where ID = ID1) name1, (Select name from name where ID = ID2) name2, (Select name from name where ID = ID3) name3 from IDNever underestimate the power of human stupidity RAH