|
Posted by JFO on 10/02/56 11:47
Table 1:
id1 name
10 - Monday
20 - Tuesday
30 - Wed..
40 - etc
Table2:
id2 - name
5 - blue
25 - red
33 - yellow
77- gree
How do I use SQL to join the tables so that the "id1" columns join on
the largest "id2" value smaller than "id1"
Result:
Monday - blue
Tuesday - blue
Wed - red
etc
Thanks
JFO
Navigation:
[Reply to this message]
|