HomeFlySpeed SQL QueryQuery build in Flyspeed not working in MySQL workbench

Query build in Flyspeed not working in MySQL workbench


I created the following query with the visual tool editor

Select * From
florence.room Inner Join
florence.rel_flo_roo On florence.rel_flo_roo.ROO_ID = florence.room.ROO_ID
Inner Join
florence.floor On florence.rel_flo_roo.FLO_ID = florence.floor.FLO_ID
Left Join
florence.fl_opname_defect
On florence.room.ROO_ID = florence.fl_opname_defect.ROO_ID Inner Join
florence.fl_uptake On florence.fl_opname_defect.Completed =
florence.fl_uptake.UPT_ID
Where
florence.fl_opname_defect.Completed = 0

when I run this on mySQL workbench I got zero records.
The query must fetch all the rows on a floor and see if their are defects in the rooms. So a few rooms have indeed fl_opname_defect records.

John
J Op hof | email
September 11 2012, 04:02 AM
Hello,

Thank you for your report. Please explain your problem in detail. Do you think that the query was generated incorrectly due to a failure in the visual query builder? If yes, please let us know, what you did and what you expected to get in result.

You may submit your detailed bug report with attachment through the "Submit a request" link or by sending it to support@activedbsoft.com. Thank you in advance.
Sergey Smagin | email
1 day, 23 hours since original post
This topic is closed