Convert mysql query to laravel ORM query

Do you already have Payment Model and Ticket Model?

You can create query something like below:

DB::table('payments', function($query) {
$query->join('tickets')
             ->on('payments.receipt', '=', 'tickets.receipt');
})
->select('payment', 'total', 'transid')
->get();

reference : https://laravel.com/docs/5.5/queries

Try this

$ticketid  = 2;// hope you have this value
$data= DB::table('tickets ')
            ->where(TICKETID ,$ticketid )
            ->join('PAYMENTS as P ', 'tickets.id', '=', 'P.RECEIPT ')
            ->select('P.PAYMENT', 'P.TOTAL','P.TRANSID ')
            ->get();

Yes i have these two models... @ mushood

@muthusaravanan

Try something along those lines

$receipt = Ticket::where('ticketid', 'Your ticket ID')->first();
$payment = Payment::where('receipt', $receipt->id)->get();

But do have a look at eloquent relations: https://laravel.com/docs/5.5/eloquent-relationships#one-to-one

It would make your life easier

Thanks for your support... @RamjithAp @somnathsah

Working fine... @mushood

Here the query

$ticketQuery = Ticket::select('ID')->where('TICKETID', $ticketNo)->get();

$paymentQuery = Payment::select('PAYMENT', 'TOTAL', 'TRANSID')->where('RECEIPT',$ticket)->get();

Thanks for your support...