Help with SELECT statement

From: Tuan Nguyen <tuan_at_cao-lanh.com>
Date: Tue, 22 Apr 2003 04:17:45 GMT
Message-ID: <4hf9avgedtm1fhs97jha1amistpe8j4els@4ax.com>

Hi all:

I have the following table called STUDENTSCORES that looks something like this:

---

| LastName | FirstName | Score | MakeupScore|

---

| Summer | Kathy | 90 | |

---

| Abad | Joe | | 95 |

---

| Wolf | Eric | 74 | |

---

| Sloan | Jim | | 65 |

---

how would i be able to select from it so that it would display all the students' names and the scores they have from the approriate column? Like

Kathy Summer 90
Joe Abad 95
Eric Wolf 74
Jim Sloan 65

Thanks so much for any help!

Regards,
Tuan   Received on Mon Apr 21 2003 - 23:17:45 CDT