MySQL Forums :: Newbie :: Join Tables to form one row

Advanced Search

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
4 XYZ Latest GREEN

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
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,

Options: ReplyQuote

Subject Written By Posted
Join Tables to form one row paddu paddu 08/29/2010 11:42AM
Re: Join Tables to form one row Rick James 08/31/2010 12:30AM

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.