Pls can u guy's giv me lil help?

Consider query



SELECT
[Genus] & " " & [Species]&" is a "&[GrowthDuration]&" mainly grows in "&[Ecosystem]&" ecosystems." AS [Details]
FROM Main
WHERE ID ='01'

It gives me below out put:

Ixora coccinea is a P mainly grows in TT ecosystems.

I use abbriviate such as;
Growth Duration
P=Perrenial
A=Annual
and
Ecosystems
TT=Terrestrial
AQ=Aquatic

Earlier I use Switch function to decode like this
Switch(Main.GrowthDuration='A','Annual',Main.Growt
Duration='P','Perennial')

Then I add those abbriviates to a separate table called Decode

Code |Orginal
A |Annual
P |Perrenial

I use below query

SELECT Main.ID, Decode.Orginal
FROM Main LEFT JOIN Decode
ON Main.GrowthDuration = Decode.Code

Now I need to combine this into generate a pharagraph such as this:

Ixora coccinea is a Perrenial mainly grows in Terrestrial ecosystems.

Quite confusing 4 me, Can u guys giv lil help.