Hi all!
I have the following Problem.
I have a MS-SQL Datasource and 2 tables
Table1 Cars
ID - CAR
1 - VW
2 - Audi
3 - Mercedes
4 - Skoda
Table2 CarColor
IDCAR - Color
1 - red
1 - blue
1 - silver
2 - black
2 - green
3 - blue metallic
3 - black
3 - blue
3 - red
etc.
The query is so far:
select * from cars, carcolor where cars.id = carcolor.idcars
But now the User can say, he only wants 2 Results for one Car.
Par example:
The Result:
VW - red,blue
Audi - black,green
Mercedes - blue metallic, black
What have I to do, to get this result?
Should I make a SP with a cursor?
sl,
Albert
I have the following Problem.
I have a MS-SQL Datasource and 2 tables
Table1 Cars
ID - CAR
1 - VW
2 - Audi
3 - Mercedes
4 - Skoda
Table2 CarColor
IDCAR - Color
1 - red
1 - blue
1 - silver
2 - black
2 - green
3 - blue metallic
3 - black
3 - blue
3 - red
etc.
The query is so far:
select * from cars, carcolor where cars.id = carcolor.idcars
But now the User can say, he only wants 2 Results for one Car.
Par example:
The Result:
VW - red,blue
Audi - black,green
Mercedes - blue metallic, black
What have I to do, to get this result?
Should I make a SP with a cursor?
sl,
Albert