Hi Need help with Left join There are two queries as below Query1 index=abc  sourcetype=123   |  table a.b.requestGUID  EmplId Query 2 index=adef  sourcetype=456   |  table c.requestGUID  VacationStartDate In query 1 the request guid is under an object b within an  object a (hence a.b.requestGUID) In query 2  the request guid is under a different object c (hence c.requestGUID) what is the syntax to join query 1 & 2 on guid under two objects and see if an employee has a vacation coming up ( basically get Guid, emplID vacatioStartDate in one shot.) These two queries only have guid as common field but they are under different objects.   Thanks, for the help     ... View more