MySQL Forums
Forum List  »  Newbie

Join Tables to form one row
Posted by: paddu paddu
Date: August 29, 2010 11:42AM

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

Options: ReplyQuote


Subject
Written By
Posted
Join Tables to form one row
August 29, 2010 11:42AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.