I am trying to move, or copy data from 1, 2 or both current table into a new third table. The reason for this is mostly to preserve the information for the image file name since it already exists on the server. I am trying to learn all forms of Joins. I just got my new book on SQL yesterday. But yes, I am hoping for a quick way (relatively speaking) to do this.
My end goal, though simplified here, is to pull up a new insert form where there is a menu/list on the left and a menu/list on the right. They are dynamically updated from both current tables. These lists have a value of the id in each table, and a label of the name in each table.
Once "Name1" is selected and "Name2" is selected, and you click submit, the Name, ID and Image_name for both are inserted into the new table. Right now, all I can get is the IDs to show up in the new table.
But to be totally honest, I'd be happy right now if I could simply carry information from one table to another table. I can't even seem to do that.
For study and practice I dumbied-down my project to include only two tables. 1 current table and 1 new table.
For example. Lets say tbl_user has ID, Name, Image.
tbl_orders has a column for ID, Name, Image, OrderID, Comments
How would I select a users name in a form, enter the new OrderID and some comments and have the ID, Name, and Image from tbl_user automatically come along for the ride?
Any help in the right direction for both INNER JOINS for two tables and the Loop would be appreciated.