MYSQL and operator
SELECT
Registration.R_no,
Registration.P_name,
Registration.Registerno,
DailyEntry.Tokenno,
DailyEntry.ArrivalTime,
DailyEntry.ConsultationTime,
DailyEntry.DispencngTime,
DailyEntry.token,
DailyEntry.prior,
DailyEntry.priorvip,
DailyEntry.delete_token
FROM
Registration,
DailyEntry
WHERE Registration.R_no = DailyEntry.R_no
AND Registration.R1_date = '2013-09-10'
ORDER BY DailyEntry.Tokenno
This sql command is returning an empty row. But data is there in the
table. Anybody please tell what is the problem
No comments:
Post a Comment