thx ur solution, but my situation is that i want to get the table name from a query result.
for exmaple
i run sql "select invoiceid, customerid from invoice, customer where invoice.invoiceid = customer.invoiceid", and get a resultset, how can i know these two columns belong to which...