mysql WHERE not working with LEFT JOIN

Question

I have, thanks to some help, got the LEFT JOIN working but need it to show selected results based on whether the record is active or not. These are either marked Y or N in the records.

The code is

SELECT suppliers.ID, suppliers.Suppliername, suppliers.postcode, suppliers.address, 
    suppliers.phone, suppliers.fax, suppliers.email, suppliers.website, suppliers.imagename, 
    suppliers.Active, suppliers.RepID, repdetails.RepID, 
    repdetails.RepName, repdetails.RepEmail, repdetails.RepPhone 
FROM suppliers LEFT JOIN repdetails 
    ON suppliers.RepID = repdetails.RepID 
ORDER BY Suppliername ASC

It used to work by using the URL ?Active=Y or ?Active=N but I cannot fathom how to get this working again.

Any help would be appreciated as I'm a newbie :)

[MySQL join with where clause](http://stackoverflow.com/q/1219909/2298301) — Dhruv Saxena, May 22 '17 at 00:49

score 1 · Accepted Answer · answered May 22 '17 at 00:49

SELECT suppliers.ID, suppliers.Suppliername, suppliers.postcode, suppliers.address, 
    suppliers.phone, suppliers.fax, suppliers.email, suppliers.website, suppliers.imagename, 
    suppliers.Active, suppliers.RepID, repdetails.RepID, 
    repdetails.RepName, repdetails.RepEmail, repdetails.RepPhone 
FROM suppliers LEFT JOIN repdetails 
    ON suppliers.RepID = repdetails.RepID 
WHERE suppliers.Active = "y" ORDER BY suppliers.Suppliername ASC

Try this

mysql WHERE not working with LEFT JOIN

1 Answers1