Hello yet again
here is my problem
i have two tables
one is Clients the other is Destinations
in Clients i have ID , name and DEST1,DEST2,DEST3
in Destinations i have to fields DESTID and description
now the thing i want to do is
is after each DEST to get the maching description
something like
select A.ID, A.name, A.DEST1, (B.description) as Descrition1 ,A.DEST2 ,(b.description) as description2 ,A.DEST3, (B.description) as Descrition3
any ideas ???
here is my problem
i have two tables
one is Clients the other is Destinations
in Clients i have ID , name and DEST1,DEST2,DEST3
in Destinations i have to fields DESTID and description
now the thing i want to do is
is after each DEST to get the maching description
something like
select A.ID, A.name, A.DEST1, (B.description) as Descrition1 ,A.DEST2 ,(b.description) as description2 ,A.DEST3, (B.description) as Descrition3
any ideas ???