Okay,

so after banging my head on the keyboard for about an hour - I give up. Does anyone know how I would do this, or if I even could?....


PHP Code:
I have two tables:
----------------------------
categories:
---------------------------
catid name
1       this is the firstname
2       this is the secondname

----------------------------
access:
----------------------------
groupid catid
1         2

I want to select only the items from access where groupid 
1
but all of the ones from categoriesregardlessI need a 
result that looks like
:

catid groupid name
1                 this is the firstname
2      1       this is the secondname