Hello,

i have one tableX:
Username (PRI) Date1 Date2
------------------------
demo 2004-03-02 2004-03-01
testy 2004-03-20 2004-03-04

And i have a tableY:
Date(PRI) Attr1 Attr2
-----------------------
2004-03-02 A B
2004-03-03 C D
2004-03-04 E F

User testy is logged in!

So i need a global, which do this things:

• Find from testy the value of Date2 in tableX ( --> 2004-03-04)
• Search for this date in tableY and find in this datarecord the value of Attr2 ( --> "F")
• Print this "F" out

Can anybody help me?

Thanks in advance,

Coyu