Transferring data from one table to another table

hello friends :slight_smile:

I’m dealing with this problem for two days. I put here the screenshot for easier understanding.Sorry about my bad english.

Here is the ss

I don’t want to inner join or table join. All image links which same sku should displayed in single row where products.resimler colon

Why do you not want an inner join? That is what it is for. If you want to do in incorrectly, you could use an update statement to add the image you want to that row, but as I said, that would break normalization.

Thank you for value comment. I know normal method is inner join statement. I can join the tables but i want to one table.Because i can import single csv file for e-commerce script.How can I use a update query for list multiple images in table products.

I thought you were asking for a single image to be included. In the case of using all of the images, personally, I would create a view with the join, and then export the data coming in through the view. It will work better without effecting your current database.

+1 on the view.

Sponsor our Newsletter | Privacy Policy | Terms of Service