Combining Parent-Child Relationship Query with Child-Parent Relationship Query

I have two different relationship queries, one is parent-child and the other child-parent:

SELECT a.Id, cc.LastName FROM Case a, a.Contact cc

SELECT Id, (SELECT Field, NewValue FROM Histories) FROM Case

How do I combine it into one query?

Superfell
select id, contact.lastName, (select field, newvalue from histories) from case

Software Engine

Hi,

What is the parent table for Campaign, User Tables

Need an account? Sign Up

Have an account? Sign In