[RESOLVED] MySQL query to return all rows from table1 and all the rows from table 2 where

[blackbox]

Hi all,

I am trying to construct a MySQL query that returns all the rows from (Table1) where the "Active" column contains "1" AND all the rows from (Table2) where the "RID" contains the same value.

Below is the query which cannot be correct as it does not return all the columns from Table1.

Is there a way that this can be done?

SELECT
Table1.SeqH,
Table2.RID,
Table2.SID
FROM
Table1
LEFT OUTER JOIN Table2 ON Table1.SID = Table2.SID 
WHERE Table1.Active = 1 AND Table2.RID = 'NXLHR01011470490135'

Any help with this would be great.

Thank you in advance for your time.

Blackbox

[blackbox]

blackbox;11057007 wrote:

Hi all,

I am trying to construct a MySQL query that returns all the rows from (Table1) where the "Active" column contains "1" AND all the rows from (Table2) where the "RID" contains the same value.

Below is the query which cannot be correct as it does not return all the columns from Table1.

Is there a way that this can be done?

SELECT
Table1.SeqH,
Table2.RID,
Table2.SID
FROM
Table1
LEFT OUTER JOIN Table2 ON Table1.SID = Table2.SID 
WHERE Table1.Active = 1 AND Table2.RID = 'NXLHR01011470490135'

Any help with this would be great.

Thank you in advance for your time.

Blackbox

SOLVED

SELECT
Table1.SeqH,
Table2.RID,
Table2.SID
FROM
Table1
LEFT OUTER JOIN Table2 ON Table1.SID = Table2.SID AND Table2.RID = 'NXLHR01011470490135'
WHERE Table1.Active = 1 

That worked.