Is it possible that i can query all the number of record in tables at =
the same time?


for example :
SELECT COUNT(*) FROM table1

what if table1 is related with table 2 so the query is=20

SELECT table1.ID, Count(table2.ID) AS Count_Of_ID FROM table1 RIGHT =
JOIN table2 ON table1.ID =3D table2.Related_ID GROUP BY table1.ID;

what if i got 4 tables or higher than 4 tables?

DB2 & UDB email list listserv db2-l LazyDBA home page