Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have two table (for ex, AI, AVI), both table having common column is ID this details display into table box, when user click Name filed in AI table, now client want expecting whatever associate record display into AVI table please hel me , what way can I proceed, i am tried Trigger but no propper output?
AI:
ID | Name | Desccription |
101 | ABC | Checking data quality |
102 | BCD | Maintain data quality |
103 | CDE | Check Data quality |
AVI:
ID | Version No | Status |
101 | 1 | Assign |
101 | 2 | WIP |
101 | 3
| Completed |
Regards,
Senthil.K
left join AI to AVI with ID as key