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