How to display vendors own products on the vendors own store page

HI all,

Anyone know if it is possible to display automatically all of a vendors products on thier pown store page.

I understand that at this point in time MV version 3 does not support this but it sure would be handy if there was a way or code already exists to display the products as above.



If we could get a hold of a database query where we only had to pass in a vendor ID that would help. Then we could throw the results into our own custom vendor templates.