Link two list into separate list

Question

I need to link two list and display them in a separate list. I refer many sites, all that they did is displaying in a data view. How can i do this?

Answer 1

Using custom code http://sujeewaediriweera.wordpress.com/2012/02/18/list-join-in-sharepoint-2010-using-caml/

Using SharePoint designer https://www.nothingbutsharepoint.com/sites/eusp/Pages/4-minute-screencast-join-view-of-sharepoint-lists.aspx

I'm not sure, you can add both list in to a Single List Other than having a joined data view.Joininglists should happen only for the view operations.