i develop a system using vb.net and microsoft access as the database. how i want to want to join between two table using the ms access and output the data in one form using vb.net?

The type of join you use is dependant upon the data you want retrived. INNER JOIN returns if only both tables contain the data, LEFT JOIN will return if data exists in either table. etc.

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature