general questions about joins in queries

[Zlatko Matić <zlatko.matic1@xxxxxxxxxxx>]

Hello.

Is it better to use A) or B) ?

 

A)

 

SELECT
 "public"."departments".*,
 "public"."plants".*,
 "public"."batches_microbs".*,
 "public"."results_microbs".*
FROM
 "public"."departments",
 "public"."plants",
 "public"."batches_microbs",
 "public"."results_microbs"
WHERE
 "plants"."department" = "departments"."department" AND
 "batches_microbs"."plant" = "plants"."plant" AND
 "results_microbs"."batch" = "batches_microbs"."batch"

 

B)

 

SELECT
 "public"."departments".*,
 "public"."plants".*,
 "public"."batches_microbs".*,
 "public"."results_microbs".*
FROM
public.departments
  INNER JOIN public.plants ON (public.departments.department = public.plants.department)
  INNER JOIN public.batches_microbs ON (public.plants.plant = public.batches_microbs.plant)
  INNER JOIN public.results_microbs ON (public.batches_microbs.batch = public.results_microbs.batch)

 

Thanks,

 

Zlatko