Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Count total records in 2 tables

843854Jun 13 2003 — edited Jun 24 2003

Hello,
I am using this query
select count(*) from table1, table2) to get the total number of records in those 2 tables. Actually I have only 7 records in both the tables, but I get 15. What could be the problem?

Also I need to find out another query where in I can find out which table is giving a particular record. e.g table1 has firstname,lastname and table2 has firstman,lastman. I need to know that firstname has come from tabl1 and firstman has come from table2.

Please help.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 22 2003

Added on Jun 13 2003

#java-database-connectivity-jdbc

15 comments

2,050 views