so I have this:
table1 = database[:account]
table2 = database[:acct_docs]
dataset = table1.where account_nbr: :acct_docs__account_nbr
I get the following error:
SELECT * FROM "ACCOUNT" WHERE ("ACCOUNT_NBR" = "ACCT_DOCS"."ACCOUNT_NBR")
Sequel::DatabaseError: Java::JavaSql::SQLSyntaxErrorException: ORA-00904:
"ACCT_DOCS"."ACCOUNT_NBR": invalid identifier
I'm guessing it wants to see: "ACCT_DOCS.ACCOUNT_NBR"
am I correct ?
if so bug ?
otherwise how can I accomplish this , and any references to doing
comparison across two tables is appreciated.
thanks
-Charles
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sequel-talk?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
