RE: Select Earliest Related Row

2016-02-10 Thread Pavel Zimahorau
em_id) Group by class_name, c. item_id I did not check it in DB and it can have some parse errors. But It should work. Best Regards, Pavel Zimahorau -Original Message- From: Don Wieland [mailto:d...@pointmade.net] Sent: Tuesday, February 09, 2016 6:57 PM To: MySql Subject: Select Ear

Select Earliest Related Row

2016-02-09 Thread Don Wieland
I have a two tables where I am adding CLASSES and CLASS_DATES for people to register for. Table Name = tl_items (Parent) item_id class_name table_name = tl_items_classes (Children) class_date_id item_id cl_date “tl_items" will have 0 to Many “tl_items_classes" using the “item_id” as the KEY f