SHARE
TWEET

Untitled

a guest Jul 19th, 2019 51 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT child_2.id, child_2.sales,child_2.country,
  2.          child_2.commission,child_2.agent_name,
  3.          child_2.created_date,child_2.created_user,
  4.          child_2.modified_user,child_2.modified_date,
  5.          child1.agent_name, parent.agent_name, parent.working_area
  6. FROM child_2  
  7.    LEFT JOIN  
  8.      child1
  9.          ON child_2.country = child1.country
  10.    LEFT JOIN  
  11.      parent
  12.          ON child1.country = parent.working_area
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top