Join 2 table using Full outer join for MS SQL Server

Asked Mar 13 '21 at 01:30

Active Mar 13 '21 at 02:57

Viewed 56 times

I have 2 table to join using full outer join. I'm using Laravel 8 and using MS SQL Server as database. Below are my code:

In Controller:

$second = DB::table('src_squeeze_height')->rightJoin('src_casting', 'src_casting.2D_CODE', '=', 'src_squeeze_height.2D-CODE')
$castsqzh = DB::table('src_casting')->leftJoin('src_squeeze_height', 'src_casting.2D_CODE', '=', 'src_squeeze_height.2D-CODE')->unionAll($castsqzh)->get();
return view('table.finalscan', ['castsqzh' => $castsqzh]);

This code return error:

syntax error, unexpected '$castsqzh' (T_VARIABLE)]

Where did I do wrong ?

edited Mar 13 '21 at 02:57

user3783243

5,368
5
22
41

asked Mar 13 '21 at 01:30

wan programmer

You're using `unionAll($castsqzh)` before `$castsqzh` is defined. I think you want to do this `unionAll($second)` – MAY Mar 13 '21 at 01:39
Thank you for recommendation but the error still same – wan programmer Mar 13 '21 at 01:56
Every line in PHP must be closed by a semi-colon. – user3783243 Mar 13 '21 at 02:57
Does this answer your question? [PHP parse/syntax errors; and how to solve them](https://stackoverflow.com/questions/18050071/php-parse-syntax-errors-and-how-to-solve-them) – user3783243 Mar 13 '21 at 02:57
Yup I accidentally miss the semi-colon, after I add that new error is occur which the : Undefined variable: castsqzh I clearly declare the variable for castsqzh – wan programmer Mar 13 '21 at 03:06
Need more context. I see `return` is this a function, and if so is the usage outside? – user3783243 Mar 13 '21 at 11:30
yup I want to display the result of join table to view – wan programmer Mar 15 '21 at 00:34

Join 2 table using Full outer join for MS SQL Server

0 Answers0