Query Question

[villsthearcher]

Hello,

I have a Query1 that uses 3 Tables (A, B, C) involving Left Outer Joins. When I RUN the query, it lists all the common records in the database. It works fine!

I created a similar Query2 like the one above, but instead of having 3 Tables, I used a QUERYA and 2 Tables. Basically the QUERYA is just a query of Table A. So I am using Tables (B, C) and QUERYA. But when I run this query it gives me an error message! But when I give criteria value for one of the fields, it gives me the correct row.

Can anyone help me why this happens?

Thanks,
villsthearcher

 

[Golom]

Please post your SQL and the error message that you're seeing.