[SQL] is it possible to get the number of rows of a table?

2001-09-26 Thread Frederick Klauschen
I would like to compare the number of rows of one table and of another and use it in a query like this: SELECT * FROM WHERE "number of rows of table " EQUALS "number of rows of table " i.e. I only want get a query result if the tables have the s

Re: [SQL] is it possible to get the number of rows of a table?

2001-09-27 Thread Haller Christoph
> > I would like to compare the number of rows > of one table and of another and use it in > a query like this: > SELECT * FROM > WHERE "number of rows of table " > EQUALS >"number of rows of table " > i.e. I only want get a query result if th

Re: [SQL] is it possible to get the number of rows of a table?

2001-09-26 Thread Wei Weng
f Of Frederick Klauschen > Sent: Wednesday, September 26, 2001 11:15 AM > To: [EMAIL PROTECTED] > Subject: [SQL] is it possible to get the number of rows of a table? > > > I would like to compare the number of rows > of one table and of another and use it in > a query l