I have to choose data from two tables. However you will find two posts, where if either rows read NO, I wish to skip it.

Table 1

a--b--c-
1  r  l
2  t  f
3  d  c

Table 2

d--e--f--g-
1  r NO NO
2  r YES NO
3  r YES YES

QUERY:

 SELECT
    talbe1.a,
    table1.b,
    table1.c,
    table2.d,
    table2.e,
    table2.f,
    table2.g,
    FROM table1 INNER JOIN 
    table2 on table1.b = table2.e
    WHERE 'no' NOT IN (SELECT table2.f, table2.g FROM table2)

Ought to be as easy as this:

  SELECT
    talbe1.a,
    table1.b,
    table1.c,
    table2.d,
    table2.e,
    table2.f,
    table2.g,
  FROM table1 INNER JOIN 
        table2 on table1.b = table2.e
  WHERE table2.f <> 'NO' AND table2.g <> 'NO'

Do this:

SELECT
  table1.a,
  table1.b,
  table1.c,
  table2.d,
  table2.e,
  table2.f,
  table2.g,
FROM table1 
LEFT JOIN table2 ON table1.b = table2.e
WHERE table2.f <> 'NO' AND table2.g <> 'NO'

Also unsure concerning the structure of the tables, but it is possible to reason you are joining on table1.b = table2.e?

Why don't you state that f=g and g='YES'?

SELECT
    talbe1.a,
    table1.b,
    table1.c,
    table2.d,
    table2.e,
    table2.f,
    table2.g,
    FROM table1 INNER JOIN 
    table2 on table1.b = table2.e
        //if any of the f or g are not eqaul to "NO" only then select the result
        WHERE (table2.f != 'NO' AND table2.g != 'NO')

does not return if 
f = no and g = no
f = no and g = yes
f = yes and g = no

does return if
f = yes and g = yes

What about:

WHERE (table2.f <> 'no' AND table2.g <> 'no')

Make use of LEFT JOIN not INNER JOIN

SELECT
    talbe1.a,
    table1.b,
    table1.c,
    table2.d,
    table2.e,
    table2.f,
    table2.g,
  FROM table1 LEFT JOIN 
        table2 on table1.b = table2.e
WHERE table2.f <> 'NO' AND table2.g <> 'NO'