I do not know programing, but I can use SharePoint for my requirements. I want to connect two SharePoint lists in to one. Lookup column is not enough to meet my requirement, is there any way to link two lists ?
Look up column connection is a straight way to implement this but as you said lookup column didn't work for you, not clear on this why didn't work.
Similar question already has been discussed here:
Follow this link to do some work around - same implementation is done here:
If you are ok to buy some third party tool to implement this, you can go with the boostsolutions integration, just plug and play :-)
To merge two lists in SharePoint Online, you can create Linked data source in SharePoint Designer.
Refer to the following article about how to link two lists and create a combined view in SharePoint 2013 (Which is also works in SharePoint online):