I've been struggling for a while now. Can someone help me?
I have 2 tables.
I have a table 'SKUS_info' with SKUS(a number assigned to a product), approximately about 30k rows.
I want to fill the table SKUS_info with the data from the table truckparts_info
What I tried to do:
I wrote a script:
select v.sku, v.net_price t.TTC_TYP_ID, t.CAR_BRAND,t.CAR_MODEL, t.CAR_TYPE, t.CAR_BODY, t.CAR_OF_YEAR, t.CAR_KW, t.CAR_PM, t.CAR_CC, t.ART_NAME, t.ART_GROUP, t.PARTS_INFO, t.ART_CROSS from truckparts_info t inner join skus_info v on t.OE_NUMBER= v.SKU order by v.SKU
But it does exact opposite of what I need. The v.SKU and v.Net_price are being added to the table B and the query result shows 500k rows in the end.
Any ideas how to change the script the way I want?
In this case you can see that SKU, Net_price are added to the table B