No link between tables!

[saramaia]

Hi!

I have a report that includes 2 tables. But they don´t have a natural join between them. We could say they are agregated tables.

I wanted to the a report which counted me hoe many records of a certain type i have in each one of those tables.

Basically, what i wanted was something like generate 2 queries so that i didn´t have to link tables and get the right results.

I know i can´t do this. But does anyone know some way i can solve this??

Thanks in advance

Sara

 

[AndrewBaines]

Use a UNION in SQL Andrew Baines
Chase International

http://www.chase-international.com

 

[saramaia]

That won´t work because i want to count registers in each table.... not both at the same time!!

 

[AndrewBaines]

You'll have to use a subreport then.

Andrew Baines
Chase International

http://www.chase-international.com