SELECT SYNTAX PROBLEM

Master table A
 LineCd
 Dscr

Detail Table B
  SubLineCd
  LineCd
  Dscr

I have multiple records in table A that have one associated record in B where B.Dscr = 'Foo' and an associated record in B where B.Dscr = 'Bar'. How do I select these records?

--
Jim Poe ( jpoe_at_fulcrumit.com )