I’m trying to set up a query form in Base that should have 2 joins to the same table as described in This thread.
I tested the SQL in a Query in the .odb file, and it works. If I open the query, the names from the joined personnel table show up correctly. However, in my query form I set the data source to “Query” and select that query, those two fields are blank for all rows. Seems like a bug to me. Why would it work as an independent Query and not as a query form in a form?
Addendum:
Version: 7.0.6.2 (x64)
Build ID: 144abb84a525d8e30c9dbbefa69cbbf2d8d4ae3b
CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
Addendum2 (The SQL of the Query):
SELECT `w`.`id`, `e`.`login` `order_received_by`, `r`.`login` `order_reviewed_by`, `w`.`DATERECEIVED`, `w`.`REVDATERECEIVED`, `w`.`CUSTOMERPO`, `w`.`REVCUSTOMEREPO`, `w`.`CONTRACT`, `w`.`REVCONTRACT`, `w`.`QUANTITY`, `w`.`REVQUANTITY`, `w`.`PARTNO`, `w`.`SPECIALINSTRUCTIONS`, `w`.`REVSPECIALINST`, `w`.`NOTES`, `w`.`CUSTOMER_OVERRIDE`, `w`.`REVCUSTOMER_OVERRIDE`, `w`.`SHIPPINGADDRESS_OVERRIDE`, `w`.`REVSHIPPINGADDRESS_OVERRIDE`, `w`.`SHIPPINGADDRESS2_OVERRIDE`, `w`.`REVSHIPPINGADDRESS2_OVERRIDE` FROM `metrology`.`workorders` `w`, `metrology`.`personnel` `e`, `metrology`.`personnel` `r` WHERE `w`.`orderrecby` = `e`.`id` AND `w`.`reviewedby` = `r`.`id`