Retrieving datas from 2 database tables and display in JTable

Hi, anybody know how to retrieve datas from 2 database tables and display in JTable?

Lets say i have 2 database table A and B

I need retrieve all datas from A but only 1 column of the data in B and display out in a JTable..

anyone had any idea how to do that?

I had manaed to retrieve all the datas from database table A but how do i retrieve only 1 column of data from database table B and dislay it out combined ina JTable?

[456 byte] By [Krissa] at [2007-10-2 10:08:11]
# 1
You get the ResultSet and copy the data from the ResultSet to the DefaultTableModel.It doesn't matter that the data comes from two different tables. You SQL query will only return a single ResultSet. So you just need to built your SQL query correctly.
camickra at 2007-7-13 1:26:18 > top of Java-index,Desktop,Core GUI APIs...
# 2
i want Retrieving datas from database tables and display in JTable
monerr_5a at 2007-7-13 1:26:18 > top of Java-index,Desktop,Core GUI APIs...
# 3
> i want Retrieving datas from database tables [url http://java.sun.com/docs/books/tutorial/]JDBC Database Access[/url]> and display in JTable [url http://java.sun.com/docs/books/tutorial/uiswing/components/table.html]How to Use Tables[/url]
camickra at 2007-7-13 1:26:18 > top of Java-index,Desktop,Core GUI APIs...