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 (BOB member since 2009-10-07)
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 (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 (BOB member since 2009-01-26)
Hi Ryan Bierschenk,
I resolved it .Thank you for the solution.
Kala Bhairava (BOB member since 2009-10-07)