2 tables, matching a colum in each?

[Mutley]

I want to list all the rows from "name" where the data in "name" matches "field_1" in a different table.

This is a really crazy guess to give you an idea:
[code]SELECT field_1 FROM ipb_tablespfields_content WHERE name FROM ipb_tablesmembers = field 1 FROM ipb_tablespfields_content[/code]

Anyone know how to do this? Thanks.

[artacus]

Thats what joins are for.

SELECT *
FROM table1 as t
JOIN otherTable AS o ON t.thing_id = o.thing_id
WHERE o.stuff = 'here'

[Mutley]

I don't understand that, sorry.

So my tables are:
[color=brown][i]table
  field[/i][/color]

ipb_tablesmembers
  name
ipb_tablespfields
  field_1

So what would it be? what is "AS o ON"? Thanks artacus.

[artacus]

SELECT *
FROM ipb_tablesmembers AS mem
JOIN ipb_tablespfields AS fld ON mem.name = fld.field_1

Assuming that  mem.name and fld.field_1 "match"