Hi guys,

im looking for a way to obtain data from a different table which is not directly connected to my main table, therefor i need a PU Query.

Example:

Table 1: Part Table

Table 2 (not connected): Part Specials Table with each x rows for 1 Part.

Here I want to check if the part specials table has a specific value in in, for example 'TestA', since the values in part special dont have a strict order I cant use PU_FIRST or PU_LAST.

Do you guys know a way to get the information from that table?

Thank you and best regards