This is pretty simple to describe:
Table A & B both have a date field. I need a query/procedure which will do:
SELECT A.date, { max(B.date) where B.date < A.date}
Example:
So each row contains the date of an A, and the biggest date in B which is less than this value. It seems like it should be so simple but I just can't get it to work in a query, and I don't know the syntax Sybase use for writing procedures - if I were in Oracle I'd have given up and written a FOR loop by now... but a query would be neater anyway.

Many thanks for any help.

Hi,

your question lacks a little information. Do you have any other join conditions between tables A and B?
What RDBMS are you using (Oracle, DB2, SQLserver, etc)?

But let's give it a try (this is based on Oracle):
select a.date
     , max(case
           when a.date > b.date then b.date
           else null
           end)
from table1 a
   , table2 b
where join_condition
group by a.date