|
Try to use rs.getMetaData() to see what are the column names. I don't think you will get the column names prefixed with table names. On the other hand "select *" is not such a good idea. It is way better to specify what columns you want exactly and in what order and to specify your own names in case of duplication.
One thing I don't understand is the purpose of your query. I don't know Access but it looks like you are gonna get a cartesian product of all the rows in the two tables. Is this what you want?
__________________
Daniel @ [
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
]
Language is froth on the surface of thought
|