MYSQL Select from another column

Question

Ok I have two tables. First table is fmp_leads. Second table is sic_codes

fmp_leads has a bunch of lead data, including a column called sic_code

sic_codes has 3 columns (id, sic_code, good_bad)

I want to run this:

SELECT * 
FROM fmp_leads 
WHERE (
    fmp_leads.sic_code MATCHES sic_codes.sic_code 
    AND sic_codes.good_bad = good
)

I realize that statement above isn't real, I'm just not sure how to perform the WHERE statement.

erewok · Accepted Answer · 2016-02-24 15:21:36Z

3

You probably want to JOIN the two tables ON the field you care about and use = in your WHERE clause:

SELECT * FROM fmp_leads fmp
JOIN sic_codes sic
ON fmp.sic_code = sic.sic_code 
WHERE sic.good_bad = 'good';

answered Feb 24, 2016 at 4:13

erewok

7,9154 gold badges37 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Beautiful. I just had to add single quotes around the last 'good'. Thank you.

Freddy Sidauruk · Accepted Answer · 2016-02-24 04:30:51Z

0

well this is another way to get data you want to,

when you are trying grab data from that table use where a.sic_code=b.sic_code

Here is all query

select * from fmp_leads a, sic_codes b 
where a.sic_code=b.sic_code and b.good_bad ='good'

Note : Just use operator and, or based on you need it and to prevent repeatation using order by id from main table

answered Feb 24, 2016 at 4:20

Freddy Sidauruk

2926 silver badges18 bronze badges