[Resolved] [Resolved] table joins

Shawazi

I'm horrible with table joins so I need some help.
Table A has an ID column
Table B sometimes crosses table A by having a column with Table As ID.

Can I select items from Table A only if they are crossed on Table B?

Example:

Table A:
ID | NAME
1 | Item 1
2 | Item 2
3 | Item 3

Table B:
ID | Table A ID| INFO
1 | 2 | Information

A query that will only pick Item 2.

Thanks for any help.

LordShryku

Should be a quick and painless join.

SELECT a.name
  FROM table_a a, table_b b
 WHERE a.id = b.table_a_id

Shawazi

SELECT DISTINCT a.id
FROM products a, pictures b
WHERE a.id = b.pid
ORDER BY rand( )
LIMIT 16

This works but I forgot I need to get another value from products being the column public. My book doesn't even show how to do joins like these It only shows syntax if I'm stating inner our outer.

Shawazi

NM I figured it out. Thanks.

SELECT DISTINCT a.id, a.public
FROM products a, pictures b
WHERE a.id = b.pid
ORDER BY rand( ) 
LIMIT 16