Based on my travel booking experience, I guess that the booking reference might contain the invoice number, whereas the SQL we're talking about looks for invoice numbers which contain the booking reference. But that's a guess, like Stephan says it would help to see actual data.
posted 1 month ago
Stephan van Hulst wrote:Try the following:
This was giving more data rather than filtering it,
Din't have much time to look into the reason.
Maybe because bookingRef is a list of different bookings and invoice is another list of different invoices containing booking references in it.
Ended up making a small utility for the same in java.
But, your code dint break.