Copying columns from two seperate tables via SQL
I am working with Magento and need to create a table in the database which
will contain both the sku and stock values for a cron job which will be
set up later. These columns sit in seperate tables elsewhere in the
database, if that makes sense. I have tried to do this via SQL but for
some reason I am getting a table with twice as many rows as I need. The
stock level rows end and then the sku rows begin. I have googled this
without any joy. Please can anyone help? I just want to pull across two
columns from two seperate tables within the same database and have them
sit inline with each other.
No comments:
Post a Comment