Answers

• rf1234 Posts: 2,806Questions: 85Answers: 406

  May 2018 edited May 2018 Answer ✓

  Editor doesn't provide an INNER JOIN but you can use LEFT JOIN and check for IS NOT NULL regarding the key you are joining. That gives you the same result.

  select 
  t.name,
  c.name,
  s.company_name,
  t.start_date,
  t.end_date,
  t.start_budget,
  t.end_budget,
  t.start_actual,
  t.end_actual,
  t.cost_code,
  t.gst
  from task t, project p, suppliers s, category c 
  where t.supplier_id = s.id 
      and p.id = t.project_id 
      and c.id = t.category_id
  

  can be written as

  SELECT
  t.name,
  c.name,
  s.company_name,
  t.start_date,
  t.end_date,
  t.start_budget,
  t.end_budget,
  t.start_actual,
  t.end_actual,
  t.cost_code,
  t.gst
  FROM task t
  LEFT JOIN category c   ON  c.id = t.category_id
  LEFT JOIN project p    ON  p.id = t.project_id 
  LEFT JOIN suppliers s  ON  s.id = t.supplier_id
  WHERE c.id IS NOT NULL
    AND p.id IS NOT NULL
    AND s.id IS NOT NULL
  

  Just write this the Editor way with the back end library you are using (PHP or whatever you are using).
• allan Posts: 61,665Questions: 1Answers: 10,096 Site admin

  May 2018 Answer ✓

  Awesome - thanks @rf1234. I've bookmarked this myself.

  Allan
• devinder1995 Posts: 5Questions: 2Answers: 0

  May 2018

  Thanks a lot .It is working now