Barand Posted September 24, 2018 Share Posted September 24, 2018 What has changed? That query looks like the previous one. Link to comment Share on other sites More sharing options...
shan2batman Posted September 24, 2018 Author Share Posted September 24, 2018 i added another table here just posted to let you know the changes.Plus isn't there any way for me to get those unique values???? @Barand Link to comment Share on other sites More sharing options...
shan2batman Posted September 24, 2018 Author Share Posted September 24, 2018 26 minutes ago, shan2batman said: i added another table here just posted to let you know the changes.Plus isn't there any way for me to get those unique values???? @Barand plus i'm willing to give data as it is not live Link to comment Share on other sites More sharing options...
Barand Posted September 24, 2018 Share Posted September 24, 2018 38 minutes ago, shan2batman said: Plus isn't there any way for me to get those unique values? As stated, I have no idea what purpose the query is to achieve. You just seem to be aimlessly selecting everything from every table. Link to comment Share on other sites More sharing options...
shan2batman Posted September 24, 2018 Author Share Posted September 24, 2018 1 hour ago, Barand said: I don't know. The query is functioning correctly. I cannot advise how you should "correct" it without knowing exactly what your data is and the function of this query is. If the only thing that is different is the update_id then don't select that column. In fact you shouldn't be using "select star". Specify the columns you need. If the update_ids are different but other columns from the update table are the same, you have another normalization problem. i understand pm your email ill send the sql file it is not live so it aint harmful.@barand Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.