![]() |
Sergey Kornilov admin 7/29/2022 |
JOIN SQL queries may multiple the number of records returned, based on how the tables are linked and also what kind of data you have. The solution for you can be a subquery, that would return the contractors name based on this ID. Check "SELECT clause" section in this article. |
J
|
Jon_AK author 7/30/2022 |
Will give this a whirl. New to using PHPRunner, am figuring out where pieces & parts all fit, not 100% sure if placing the SQL code is to go in the Query section for the master table or if it is supposed to be an event. Thanks for the tip though. |
![]() |
Sergey Kornilov admin 7/30/2022 |
I think you need to modify it on a SQL screen. |