No Data in View

Hello,

First of all, I am a novice at using heidisql so pardon me if my explanation of my problem is overgeneralized.

I am using heidisql for a homework assignment. The homework calls for me to create a view with certain tables. I can see where the view is created, but there is not output. What am I doing wrong? Here's what I wrote:

create view NHTrips AS
select TripID, TripName, StartLocation, Distance, MaxGrpSize, Type, Season
from trip
where State = 'NH';

Thanks!

When you select a view, then you should see the "Data" tab. Just click on it to see the data.

When you select a view, then you should see the "Data" tab. Just click on it to see the data.

It just shows the code. Is that all I'm supposed to see? Also, it won't let me save the view.

Thanks again!