How to select a ref ref data, like an inner join in SQL,MySQL

How to print with a select the column Photo in a email, PDF referenced for the Options table…

If i want use it in SQL or Mysql i used to inner join, or left or right joins.

How is in Appsheet?

Try:

<<[Title]>>
<<Start: [Related Notes]>>
<<[idNote].[Photo]>>
<<[Commentary]>>
<<End>>
2 Likes

i tried and non function, when a syntax error was detected the email don’t send to me. i couldn’t see the result cause i had a syntax error. My boss just teach me the “Related” with this example:
Options is the first table.
<>
print: IdNote=4321, idOptions=123, Commentary=Sweepy floor.
Show 1 register when you are working in the app.

Resume: Related print the ref table columns, but, how I print a reference table from other reference table? And if 4 tables have the same reference and the workflow is attach to number 1, how to print the farest column? till number 4 table

Maybe just a SELECT with conditions? Can be,

I’m afraid I’m lost. I don’t understand what’s happened.

Is this still a problem? If so, please provide a creenshot of the error message.

I have no idea what this means.

I don’t know what this means.

I don’t know what this means.

I don’t know what this means.

I don’t know what this means.

For what?

Sorry.

Yes, Still the problem, I’ts impossile see the error. Atention: when i print in PDF to see the results show me all information, if has a little error like <> the PDF didn’t send me and i can’t see what happend.

I know how select the information with 1 ref because someone teached me.

Resumen in English: Summary: ok I know a new word today!

whatever :cold_face:.

I asked to a friend without knowledge from appsheet, This friend told me how to use an inner join whitout innerjoin.

For the first photo to show the field PHOTO:
Select * from Notes, Notes Archive, ( select-row? [ , distinct-only?])

What do you recommend me?