Select query from two tables which only specified rows [closed]

Question

I want to try querying two tables, like this:

user_id   primary_indicator
-------   -----------------
9012445   Y
9012445   N
9012442   N
9012332   Y
9012332   N
9012445   
9012332

access_id user_id
--------- -------
00014359  9012445
00014323  9012442
02349995  9012332

I want to get access_id where primary_indicator in table A is 'N'.

How can I do this?

Petter Brodin · Answer 1 · 2013-01-30 04:52:50Z

I'm not sure what you mean by your final sentence:

as what i tried, i cannot get a clear access_id where primary_indicator is 'N' can u help me

Doesn't it work just to do it like this?

SELECT b.access_id
FROM a
JOIN b ON a.user_id = b.user_id
WHERE a.primary_indicator = 'N'

If that's what you're looking for, you should read up on the subject of JOINS, as they're fundamental to querying multiple tables at once.

closed as off topic by Leigh Riffel, dezso, RolandoMySQLDBA, Mark Storey-Smith, ypercube Jan 31 at 13:19