Displaying values from tables other than primary

[excalibr]

(sorry forgot subject line in previous post)

Greetings,

We're writing a report which looks like this (in the page header section):

Total of X for month: 123
Total of Y for month: 345

SQL for X -> select count(*) from tableX where fieldX = "xxx"
SQL for Y -> select count(*) from tableY where fieldY = "yyy"

Does anyone know how to display values (or functions of values) from tables other than the primary table currently reported on?

Thanks very much, Excalibur