thanks again, AM. no need to have this extra trouble, as I just asking
this as a matter of curiosity. it thought it was something rather simple
as hell :)
best regards,
richard.
On 03/19/2014 09:50 PM, AM wrote:
Not at my desk so I cannot test this, but IIRC in the select you can
specify
Hello.
On 20.3.2014 12:13, Richard Gerd Kuesters wrote:
thanks again, AM. no need to have this extra trouble, as I just asking this
as
a matter of curiosity. it thought it was something rather simple as hell :)
I think the following:
q = session.query(A, B).filter(A.b_id == B.id)
print q
#
thanks Ladislav!
yup, that one gives me what i want, but i was kinda working on plain
select([col1, col2], from_obj=) function :)
but nevermind bothering, its just part of a building process that's i'm
writing in SA (instead of making them by hand), people are used to do
selects like
well ... just bumped at Bundle. it does the job :)
http://docs.sqlalchemy.org/en/rel_0_9/orm/query.html?highlight=aliased#sqlalchemy.orm.query.Bundle
best regards,
richard.
On 03/20/2014 02:20 PM, Richard Gerd Kuesters wrote:
thanks Ladislav!
yup, that one gives me what i want, but i was
hi, i have a simple stupid query question, which i didn't found any
examples. let's say i have table A and B, and would like to reproduce in
SA the following SQL:
SELECT A.*, B.* FROM A, B WHERE A.b_id = B.id
i would probably need a new fuse, too ...
best regards,
richard.
--
You received
On 03/19/2014 02:07 PM, Richard Gerd Kuesters wrote:
hi, i have a simple stupid query question, which i didn't found any
examples. let's say i have table A and B, and would like to reproduce
in SA the following SQL:
SELECT A.*, B.* FROM A, B WHERE A.b_id = B.id
i would probably need a new
thanks AM!
i know that a join have the same effect (that's why i
already told it's probably stupid question), but i was wondering if the
select ... from tbl1, tbl2 is possible using SA. that's all :)
cheers,
richard.
Em 2014-03-19 20:11, AM escreveu:
On 03/19/2014 02:07
PM, Richard
On 03/19/2014 04:44 PM, Richard Gerd Kuesters wrote:
thanks AM!
i know that a join have the same effect (that's why i already told
it's probably stupid question), but i was wondering if the select ...
from tbl1, tbl2 is possible using SA. that's all :)
cheers,
richard.
Em 2014-03-19