SQl query help

[kronnos]

Ok after about 6 hours, I think I figured out exactly what fields i would need to move the data from and to.

I would like to move data from the "From_subscriptions_data" table to the "To_subscriptionlog" table. I specified the default values for field that would not be imported from the "From_subscriptions_data" table.

The next move is from the one table "From_payments" to two different table called "To_paymenttransaction" and "To_paymentinfo". A lot of the field should just have default data that i specified.

Below is the chart with the table names and the fields.
Looks a lot cleaner here: https://docs.google.com/spreadsheet/...W01bWI3ODFhN2c

To_subscriptionlog ----- < ----- From_subscriptions_data
subscriptionlogid --------- < ----- id
subscriptionid ------------ < ----- subid
userid ------------------- < ----- userid
pusergroupid ------------ < ----- termid
status ------------------ < ----- active
regdate ----------------- < ----- stime
expirydate -------------- < ----- etime
importsubscriptionlogid --- < ----- (Set all to "0")


To_paymenttransaction --- < --- From_payments
paymenttransactionid ------- < --- (Generate next available number in this column)
paymentinfoid -------------- < --- (Generate next avaliable number in this column)
transactionid --------------- < --- txn_id
state ---------------------- < --- (Set all to "1")
amount -------------------- < --- mc_gross
currency ------------------- < --- mc_currency
dateline -------------------- < --- payment_date
paymentapiid --------------- < --- (Set all to "1")
request -------------------- < --- (Set all to "NULL")
reversed ------------------- < --- (Set all to "0")
To_paymentinfo -----------<
paymentinfoid -------------- < --- (Same generated number that goes to the paymentinfoif field in To_paymenttransaction table )
hash ----------------------- < --- (Set all to "Imported")
subscriptionid --------------- < --- (Set all to "1")
subscriptionsubid ------------ < --- ("2" IF above field mc_gross is 4, "1" IF above field mc_gross is 6, "0" IF above field mc_gross is 10)
userid ---------------------- < --- userid
completed ------------------ < --- (Set all to "0")


The link below also has some sample data using a specific record where data was once moved the opposite way but it might be a bit confusing and the above hopefully has enough information.

https://docs.google.com/spreadsheet/...&rm=full#gid=1

Again, thanks for all the help!