Hi:
I'm having a problem with my left join. I'm joining two tables using:
x = RailCar.select(join=LEFTJOINOn(RailCar, RailStatus,
RailCar.q.id==RailStatus.q.railCarID))
if I then print x, I get:
SELECT RailCar.railCarId, RailCar.carInitials, RailCar.carNumber,
RailCar.active, RailCar.createdOn FROM RailCar LEFT JOIN RailStatus ON
((RailCar.railCarId) = (RailStatus.railCarId)) WHERE 1 = 1
The problem is that I don't get any of the fields from the RailStatus
table in the select. What do I need to do to get the fields from both
the joined tables into the result? Any pointers would be appreciated.
-Jim
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
