Special Join for MySQL (RESOLVED)

[mccareth]

Hi everyone,

Ok, I'm going to try and explain this as best as possible and show lots of examples to try and be concise. I have two tables, that looks like this:

tblSection

fldSection     fldName
--------------------------
1                 General
2                 Romance
3                 Sci-Fi
4                 Fantasy

tblCredit

fldClient     fldSection     fldCredit
-----------------------------------------
1                2                  20
1                4                  24

What I would like to do is connect these two tables, show all sections, and base it off of the Client number. The output I'm looking for would be this:

fldSection     fldName     fldCredit
-----------------------------------------
1                  General        20
2                  Romance      24
3                  Sci-Fi
4                  Fantasy

This information would be based off of the client id which is 1 in the tblCredit table.

I've tried several different variations of joins (left, right, outer, etc), but to no avail. If anyone could help me, I'd appreciate it greatly. Thank you!!!