Complex query such as UNION and JOIN are not supported. However, you can still try using it. Though the grid may display fine you will not be able to perform edit & delete operations.