The combined queries contain incompatible objects.(Error:RWI

Helloo All,
I am added 2 queries and running. It throws the error.

The combined queries contain incompatible objects.(Error:RWI 00704)

Can you people help me to resolve this.

With regards,


Kala Bhairava :us: (BOB member since 2009-10-07)

Remember that combined queries is basically a union statement in SQL. You must ensure that the elements in each query line up appropriately. Usually, this error is a direct result of not having like items in the same order.

For instance, Query 1 has (Name (varchar), Address (varchar), zip (int), SSN (int)) and Query 2 has (Name (varchar), Address (varchar), phone (int), zip (int), SSN (int)). The extra field [phone] in the second query will cause the error you are recieving. Please verify that you do have the proper field allignment in both of your queries.

Good luck!


Ryan Bierschenk :us: (BOB member since 2009-01-26)

Hi Ryan Bierschenk,
I resolved it .Thank you for the solution.


Kala Bhairava :us: (BOB member since 2009-10-07)