I’m trying to get the records from Table A that has one and only one record in Table B, I’m not interested in records that have no records in B nor that have multiple records in B,
I tried using
TableA::whereHas('tableB')->get()
This didn’t return A’s where no records in B but I still don’t need ones that have multiple in B
>Solution :
use has so you can restrict query to fetch only those record which has one record in tableB model
TableA::has('tableB', '=', 1)->get()