request from two table

[RickyD77]

hi again

i just need two make a request but i dont know how

eg

SELECT *
FROM table1, table2
WHERE date < today (=>session variable<=)
ORDER BY date

but this dosent work any sugestion

thx Eric

[jburfield]

SELECT *
FROM table1, table2
WHERE date < today (=>session variable<=)
ORDER BY date

You need to join the tables somehow.

For example:
SELECT * from table1, table2 where table1.date=table2.date AND table1.date < $today order by table1.date;

That should put you on right track...

-- Jason