Sql help please!

[Qwerty8989]

Hey

In my database I am wanting to combine two fields within my sql. To ellaborate:

SELECT PLANTEN.PLANTNAAM, PLANTEN.BL_B, PLANTEN.BL_E
FROM PLANTEN;

This results in three columns:

PlantNaam Bl-B BL-E

Tulip 4 7

I am wanting to combine the two columns, BL_B and BL_E via sql so it is displayed as:

Plantnaam flower period (alias)

tulip 4-7

I am just unsure how to do this, perhaps an IIF statement? thankyou =)

 

[gemma-the-husky]

try this

SELECT PLANTEN.PLANTNAAM, PLANTEN.BL_B & " - " & PLANTEN.BL_E as planten_full
FROM PLANTEN;

 

[Qwerty8989]

Thankyou =)