how to write this without subquery 1

[jemminger]

hi all,

how can i write this using joins instead of subqueries, so it would work on < v4.1?

(note foo_id = bar_id)

select * 
from foo_tbl
where foo_id not in (
  select bar_id 
  from bar_tbl
)

i've gotten this so far:

select *
from foo_tbl
inner join bar_tbl on bar_id = foo_id
where ???

=========================================================
-jeff

http://www.jeffemminger.com

try { succeed(); } catch(E) { tryAgain(); } finally { rtfm(); }

 

[r937]

select foo_tbl.* 
  from foo_tbl
[b]left outer[/b]
  join bar_tbl
    on foo_id = bar_id 
 where bar_id is null

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts March 6 2005)