Multi table query

Hi

Need hellp with some query I'm trying to develope.

How do I count the number of records from table X1, colum X1 and from table Y2, colum Y2?

I whould need it to presente it like this:

Total X1 Total Y2

1313412 12341324

Thanks for any help.

One way to do this would be similar to:

Code Snippet

SELECT

TotalX1 = ( SELECT count(1) FROM TableX1 ),

TotalY2 = ( SELECT count(1) FROM TableY2 )

sql