help needed in SQL Statement

[PilgrimPete]

Your original SQL statement looks OK to me.

However, are you using a DataCombo control?
If so, you need to set the ListField property (and I think the BoundField property too).