Fetch data from two tables without join laravel

Question

Want to fetch data from two different queries since employee table is too large and emp dept would be always one . I am trying to avoid join with dept table instead trying to use below query

Want to convert below query to Eloquent query

SELECT ename, 
       (SELECT dname FROM dept WHERE dept.deptno=emp.deptno) dname 
FROM EMP

Laravel fetch data from two tables without join with pagination

@Barmar had read regarding it long back. Sorry i am unable to find it right now. Could you please correct me if i am wrong — insoftservice, Oct 27 '21 at 19:42
As long as you have indexes on the `deptno` columns, the join should be fine. — Barmar, Oct 27 '21 at 19:42
I don't know Eloquent, but I found this with google: https://laracasts.com/discuss/channels/eloquent/doing-a-correlated-query-in-a-subquery — Barmar, Oct 27 '21 at 19:49

score 0 · Answer 1 · answered Oct 27 '21 at 21:36

0

You could sue this code

SELECT ename, dname 
FROM EMP, dept
WHERE dept.deptno=emp.deptno

Y hope help you

answered Oct 27 '21 at 21:36

Lamri Djamal

236
1
10

I want it in laravel format without join – insoftservice Nov 01 '21 at 12:16

Fetch data from two tables without join laravel

1 Answers1