query data from two tables using mysql -

query data from two tables using mysql -

select patient_id patient date(visit.date_started) > date(patient.date_created)

the statement think self explanatory trying do. have 2 tables, patient , visit. want patients have started visit, recorded on table, on later day when patient registered in system, patient recorded when registered. note: need returned info on patients table after filter.

try this:

select patient.id patient,visit date(visit.date_started) > date (patient.date_created)

mysql