JOIN table

Scriptcase 8 Discussion
#1

i ask, i can use join :SELECT * FROM autori
INNER JOIN libri
ON aut_id = lib_autore ,
ask i can select a value of table libri and use in table autori?

#2

Yes, you can use it. But if is for an application, you can not update directly it value to libri. You must use an event for that.

#3

If you need to update both tables in the same record… create an editable view.

Regards