如何在grails中加入Hibernate上的2表

Question

我需要帮助。我想问一下grails上的Hibernate HQL。我想把两个表合并成一个结果。

我的控制器

TRANSACTION.executeQuery("from TRANSACTION join SUBSCRIBER on TRANSACTION.subscriberID = SUBSCRIBER.msisdn where TRANSACTION.date = '2020-09-04'"

结果：意外的令牌：在上

当我像这个源代码一样更改代码时此链接

TRANSACTION .executeQuery("from TRANSACTION t1,SUBSCRIBER t2 where t1.subscriberID = t2.msisdn and TRANSACTION.date = '2020-09-04'")

结果："字段列表"中的未知列"subscriber0_pos">

我的数据库映射

class Transaction implements Validateable{
String id
String subscriberID
String currentBalance 
String date
static mapping = {
datasource 'trx'
table 'TRANSACTION'
id generator: 'assigned', column: "ID"
subscriberID column: "subscriberID"  <-- this value is equals to msisdn at Subscriber
currentBalance column: "currentBalance"
date column: "date" 
version false
}

---

class Subscriber implements Validateable{
String id   
String msisdn
String firstName
static mapping = {
datasource 'subs'
table 'SUBSCRIBER'

id column:"subscriberID"        
msisdn column:"msisdn"      
firstName column:"firstName"
version false

}

我想像这个一样加入他们

|firstName|subscriberID|currentBalance|Date|

Answer 1

我解决了它！

def query＝"；从表1 t1、表2 t2中选择表1.subscriberID、表2.msisdn，其中t1.id=t2.id"；query=table1.executeQuery(query(；