Problem with a query... too complex or wrong?

Hi! I have a quite complex problem (for me) that I don’t know how to solve.
I have two tables.


MGANA contains codart (article code) and price (listino1).
It is linked to LISTCLI by the same codart field (which may or may not exist)

If LISTCLI.codcf has a certain value (I think I’ll pass it by URL, then reading it from a GET), and the product code MGANA.codart also appears in the LISTCLI table (LISTCLI.codart) I have to show the user the LISTCLI.prezzo field (new price) instead of MGANA.listino1

I don’t know how to do this quickly!

I tried to do two queries, basing the second on one of the fields in the first.




dmx5

so I was thinking of applying a repeat, in which to base a condition that shows a value rather than another on the user’s page.
Read-only and not editable.

Then there is a cart, which I have already made and which works perfectly

I am stuck on the first step, I do not know how to go on and above all I am having the wrong way of dealing with this problem.
Could someone help me out?
Thank you!!!

Community Page
Last updated: