i need help!
I have a relation data like this:
i want to pluck 2 columns from relation mail->mail meta.
so far i have tried this:
$data= AppModelsMailRevisionHistory::with(['mail.mail_meta'])
->where('mail_id',$request->mail_id)
->first()
->pluck('mail.mail_meta.id','mail.mail_meta.key');
but i have an error like this:
{"status":1,"message":"Insert Failed : SQLSTATE[42P01]: Undefined table: 7 ERROR: missing FROM-clause entry for table "mail_meta"nLINE 1: select "mail"."mail_meta"."key" from "trx_mail_revision_hist...n ^ (SQL: select "mail"."mail_meta"."key" from "trx_mail_revision_history")"
please correct where did i go wrong