mysql table joins

[rabbitdog]

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?....

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 categories, regardless; I need a 
result that looks like:

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

[freakysid]

You want to use a left outer join. You can read a bit about them ins the mysql manual in the chapter/section that deals with SELECT queries and also an article here http://www.devshed.com/Server_Side/M...oin/page4.html

Something like this should work:

SELECT categories.catid AS catid, groupid, name
FROM categories LEFT JOIN access ON categories.catid = access.catid