Zachary Yates wrote: > > create view ProgrammingMapView as > select > p.Id ProductId > , pt.Id ProtocolId > , m.Id Mid > from Mid m > join MidProduct mprod on (mprod.RegisteredMid = m.Id) > join Product p on (p.Id = mprod.ProductId) > join MidProtocol mprot on (mprot.RegisteredMid = m.Id) > join ProtocolType pt on (pt.Id = mprot.ProtocolId) > join ProductProtocol pp on (pp.ProductId = p.Id and pp.ProtocolTypeId = pt.Id) > ; > Thanks.
It should be noted that the above view refers to other tables as well. Anyhow, the best I can come up with at this point is that the ORM package(s) really should include AS clauses in the generated SQL in order to get the desired column names, per the SQL standard. This is not a bug in SQLite nor System.Data.SQLite. -- Joe Mistachkin _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users