Hi Friends,
I am working on a project.
The requirement is like :
I have two tables : SystemDetails and URL.
System Details has fields : id, systemid, version, pingstatus
URL has fields : id, sid, url
Now i have contents
System Details
1 XYZ Latest GREEN
2 ABC Old GREEN
3 GBA Old GREEN
4 XYZ Latest GREEN
URL
1 XYZ
http://localhost1
2 ABC
http://localhost2
3 GBA
http://localhost3
4 XYZ
http://localhost1/web
Now, what i want when queried is :
1 XYZ Latest GREEN
http://localhost1
http://localhost/web
2 ABC Old GREEN
http://localhost2
3 GBA Old GREEN
http://localhost3
Means, i need to join the tables in such a way or plan in such a way that system details are not repeated and URLs are displayed in one row of SID with additional column only.
Could you please help me to achieve this?
Thanks and Rgds,
Paddu