Davis, Tim wrote:
>select count(*) from table1
>go
>select count (*) from table2
>go
>
>This will return 2 results, with count of each table. How would I do the
>same thing in MySQL?
>
>
I'm not sure if you can; I tried:
select count(table1.id) as table1_count, count(table2.id) as
table2_coun
In MS SQL, I can do the following statement
select count(*) from table1
go
select count (*) from table2
go
This will return 2 results, with count of each table. How would I do the
same thing in MySQL?
Tim Davis
Sunbelt Systems Concepts, Inc
[EMAIL PROTECTED]
Client/Server Database Programmer/A
