-
Notifications
You must be signed in to change notification settings - Fork 48
Open
Description
const sql = sqlQuery.select()
.from('machine_log')
.select('when', 'machine_id', 'event')
.from('machines', 'machine_id ', 'machine_log', 'machine_id')
.select('name')
.order('when', 'Z')
.limit(limit)
.build();And it produce this SQL that so wrong
SELECT `t1`.`when`, `t1`.`machine_id`, `t1`.`event`, `t2`.`name` FROM `machine_log` `t1` JOIN `machines` `t2` ON `t2`.`machines` = `t1`.`machine_id` ORDER BY `when` DESC LIMIT 10ON t2.machines must be ON t2.machine_id
like this
SELECT `t1`.`when`, `t1`.`machine_id`, `t1`.`event`, `t2`.`name` FROM `machine_log` `t1` JOIN `machines` `t2` ON `t2`.`machine_id` = `t1`.`machine_id` ORDER BY `when` DESC LIMIT 10Metadata
Metadata
Assignees
Labels
No labels