posted 24 years ago
Hi Guys,
I have 4 tables, viz. problem, area, engineer and complaints. While storing the data in the table of complaints, the respective ids of former three are stored. While displayng the records of complaints, i am able to get the ids of the former tables viz. problem, area and engineer and not the names. The other fiels are displayed, fine.
My problem is how do I run a SQL query, such a way that I get the names of the above mentioned tables.
The tables are as follows:
1)probelm : probid, name.
2)area : areaid, name.
3)engineer: engid, engineer.
4)complaints: compid,custname,date,time,problem,area,engineer,status.
Pls help me !