lifelineamerica
Programmer
I am trying to locate all records paid by the same card (last 4 digits were stored and column name is last_4) on the same date (column is called date_made, and is in the date_time format)
... and sadly I get zero results when there should be thousands..
Please help!
Code:
SELECT *
FROM res_reservations a
INNER JOIN res_reservations b
ON a.last_4=b.last_4
WHERE a.date_made LIKE 'b.date_made%'
... and sadly I get zero results when there should be thousands..
Please help!