我只想合并两个表的内容并基于id显示它。
两个表都有3个条目。
表a-取样顺序

Date Docname Products Quantity ID
1     A       A         1      1
2     B       B         2      1 
3     C       C         3      1

表b-代表性位置

Date Area lat long ID
 1    a    1   1   1
 2    b    2   2   1
 3    c    3   3   1

输出应该生成3行，其中所有表a列和表b列的id=specified id
我需要这样的输出

Date Docname product Quantity Area lat long
1      A       A       1       a    1   1
2      B       B       2       b    2   2
3      C       C       3       c    3   3

但是它会生成9行（3*3）并复制两个表中的行数。它的生成

Date Docname product Quantity Area lat long
1      A       A       1       a    1   1
2      B       B       2       b    2   2
3      C       C       3       c    3   3
1      A       A       1       a    1   1
2      B       B       2       b    2   2
3      C       C       3       c    3   3
1      A       A       1       a    1   1
2      B       B       2       b    2   2
3      C       C       3       c    3   3

梳理a*b中的行数-相对于id，我只需要3行。
查询-

$Report = DB::table('sampling_order')
             ->join('representativelocations','representativelocations.representativeid','=','sampling_order.representativeid')
             ->select('sampling_order.representativeid as representativeid',
             'sampling_order.date as date',
             'sampling_order.doctor_name as doctor_name',
             'sampling_order.products as products',
             'sampling_order.quantity as quantity',
             'representativelocations.latitude as latitude',
             'representativelocations.longitude as longitude',
             'representativelocations.area as area')
             ->whereBetween('sampling_order.date', [$Datefrom, $Dateto])
             ->where('sampling_order.representativeid','=',$Representativeid)->get();