I have a question about join data.Give me an advice , thank you so much !
I have table A , table B
My sql statement : select A.ProductID,A.DataA1,A.DataA2,A.DataA3,B.DataB1,B.DataB2,B.DataB3 where A.ProductID=B.ProID
In case,table B does not have any records with ProductID respectively (mean that we only have records in table A).i want to replicate data in each field as following :
A.DataA1 -> B.DataB1
A.DataA2 -> B.DataB2
A.DataA3 -> B.DataB3
if table B have records, we can get data normally !
Give me an advice or show me the way to solve problem !
Thank you so much !