I have two tables WeekDays ( id, Name) and ClassHours( Asignature, Sesion,
Day,  StartHour, EndHour)

WeekDays
1    Monday
2    Tuesday
3    Wednesday
4    Thurday
5    Friday
6    Saturday

ClassHours
MAT-011    1   2 (Tuesday)        10:00 12:00
MAT-011    1   3 (Wednesday)   10:00  12:00

Using the next sql the data is shown correctly in a grid,

select  a.*, b.*
from WeekDays as a
Left Join
(select * from ClassHours as c where c.Asignature = "SIS-202" ) as b on
a.dia=b.dia

However, when try to append exception arrises. I believe that using
BetterADODataSet works, but I do not know how to use it. There is another
way to do that using Delphi standard objects such as ClientDataSet, etc? or
do you know some tutorial or demo of BetterADODataSet ?

Pedro :

That statement is readonly, by nature, and the only we to update it is
to create separate SQL statements for each table.
May be "BetterAdoDataSet" is creating the update statement for you when
you "append" in VCL.

Regards,