| umid | reportedby | category | processpwruser | priority |
| 2 | 1 | 1 | 2 | 1 |
It all refer the ID of another table i need the name of all fields with the help of these ID
Result will like these
| umid | reportedby | category | processpwruser | priority |
| raja | kumar | tamilnadu | ajay | high |
datas are from different table
like these
Umid ,reported by, process power user from usermaster
category from category master
priority from priority master
Manish Kumar ChoudharyPosted Dec 10, 2014, 12:51 AM
just join all the table
Select umid, reportedby, category, processpwruser, priority from table1
Inner join table2 on
table1. umid = table2. Umid
- - -
- --
same way join all the table