Guest User

Untitled

a guest
Nov 19th, 2018
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.35 KB | None | 0 0
  1. select c.obl_id, c.ind_st, tm.* from TOS_MES tm join
  2. CAT_STATION c on c.ind_st = tm.ind_st join CAT_OBL o
  3. o on c.obl_id=o.obl_id;
  4.  
  5. $users = DB::table('users')
  6. ->join('contacts', 'users.id', '=', 'contacts.user_id')
  7. ->join('orders', 'users.id', '=', 'orders.user_id')
  8. ->select('users.*', 'contacts.phone', 'orders.price')
  9. ->get();
Add Comment
Please, Sign In to add comment