munna
11th March 2006, 12:47
Hi,
I have two tables called 'g_contacts' and 'name_d'. The fields in 'g_contacts' are
1. id
2. n_id(this field is 'id' field in name_d)
3. g_id.
Now, i want to select all the records in the table g_contacts with a particular g_id and then with the result of that select all the records in the table name_d where n_id(g_contacts field) is equal to id(name_d field).
How can i do this using sqltablemodel or sqlrealtiontablemodel ?
Thanks a lot
I have two tables called 'g_contacts' and 'name_d'. The fields in 'g_contacts' are
1. id
2. n_id(this field is 'id' field in name_d)
3. g_id.
Now, i want to select all the records in the table g_contacts with a particular g_id and then with the result of that select all the records in the table name_d where n_id(g_contacts field) is equal to id(name_d field).
How can i do this using sqltablemodel or sqlrealtiontablemodel ?
Thanks a lot