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:
Can anybody help me?
Thanks in advance,
Coyu
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