hi all,
got an easy oen here...
i got 2 tables in sql srvr2000. one contains galleries and the other projections.
i want to return all galleries that match a nile like '%gomez%' but only if the gallery_id is not 'trashed' in the projected table.
here is the curver ball. the projected table...