I'm just getting started with the SQL language. I have been sitting with my SQL For Dummies book for two hours now trying to figure out how to do what should be a very simple query.

I want to select TabName and TabID from the core Tabs table. I got that to work quickly but it returned tabs from the host and admin sections and hidden tabs which I don't want. I want all tabs that are not in the admin or host sections and are not hidden. So I figured I needed to do some type of join with the TabPermission table. That's where I'm stuck. Here is my last try which produced this error:  Ambiguous column name 'TabID':

SELECT TabName, TabID FROM Tabs T FULL JOIN TabPermission P ON (T.TabID = P.TabID) WHERE IsVisible = 1 AND RoleID = 1

IsVisible is a Tabs table column and RoleID is a TabPermission table column.

Greg