SELECT Table1.org, Table1.orgregn ;
FROM db!vibordata ;
INNER JOIN db!table1 ON Vibordata.nashadata >= Table1.drassm

SELECT Table1.org, Table1.orgregn, Vibordata.nashadata ;
FROM db!vibordata ;
LEFT JOIN db!table1 ON Vibordata.nashadata >= Table1.drassm

* Исходные данные
create cursor table1 (Org C( 10 ), Orgregn C( 10 ), Drassum D)
insert into table1 (Org, Orgregn, Drassum) values ("qqqqqqqqq", "3452432423", {^ 2011 - 01 - 01 })
insert into table1 (Org, Orgregn, Drassum) values ("wwwwww", "23423423423", {})
insert into table1 (Org, Orgregn, Drassum) values ("eeeeeeeee", "2342366546", {^ 2011 - 01 - 01 })

* Таблица для фильтрации данных
create cursor Vibordata (Nashadata D)
insert into Vibordata (Nashadata) values ({^ 2011 - 01 - 01 })

* Собственно выборка
select table1.Org, table1.Orgregn ;
from table1 ;
inner join Vibordata on Vibordata.Nashadata >= table1.Drassum ;
where table1.Drassum <> {}