How Block list links to a page with datas from same database table

Permalink
Suppose a table in database,

col1 col2 col3 col4
a xxxx xxxx xxxx
a yyyy yyyy yyyy
b zzzz zzzz zzzz

the col1 serve as key, and I'd like take the col1 values as titles of links list in a block on the top page, when clicked the link "a" OR the link "b", the next page will show a table with content from db talbe's first two rows for "a" or from third row for "b".

link list:
a
b

when click "a", result on next page
a xxx xxx xxx
a yyy yyy yyy

It seems according to discussions here that a page list block can do this, but I'm not sure how. Could anyone give some hint ?