Topic: SQL with join tables
Hello Dmitry
I made an application to manage my comics (MVD 1.52 v5)
On Form1 (main form), I have a grid listing all comics and on the same Form1, I have a panel
giving details for un record in the grid.
I have a main table (Comics) and many others (dictionnaires) (i.e. King of comics)
I would like to use a SQL query whose result displays informations retrieved from other tables linked with table Comics :
I've tried something like this
s := SQLExecute('SELECT Kind.kind from Comics WHERE id=' + IntToStr(Form1.TableGrid1.dbItemID) );
Form1.Label24.Caption := s;
There is no error message, but there is no information displayed for field Kind.
I think I should use instruction JOIN in my request. I've looked for this on Net but there is many cases
which are not well explained.
I traveled the entire forum (even russian forum), but all the cases submitted are simple SQL, of the ones I used to use for simple queries
Please, do you have any information about this SQL very complex (or any MVD users) ?
Thanks for your help
JB