Two ways to quote your query ?1

Try this. Is the result the same or not and why ?

SELECT DISTINCT s.pub_id
 FROM publishers S
 FULL JOIN titles sp
 ON s.pub_id=sp.pub_id
 WHERE sp.type='business '

SELECT DISTINCT s.pub_id
 FROM publishers S
 LEFT JOIN
 (SELECT sp.pub_id
  FROM titles sp
   WHERE sp.type='business ') as SP
   ON s.pub_id=sp.pub_id

Dan. Received on Thu Sep 23 1999 - 08:14:46 CDT