Barand Posted September 24, 2018 Share Posted September 24, 2018 What has changed? That query looks like the previous one. Quote Link to comment https://forums.phpfreaks.com/topic/307714-couldnt-figure-out-how-to-fetch-values-in-this-query-need-help/page/2/#findComment-1561073 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 Quote Link to comment https://forums.phpfreaks.com/topic/307714-couldnt-figure-out-how-to-fetch-values-in-this-query-need-help/page/2/#findComment-1561074 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 Quote Link to comment https://forums.phpfreaks.com/topic/307714-couldnt-figure-out-how-to-fetch-values-in-this-query-need-help/page/2/#findComment-1561075 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. Quote Link to comment https://forums.phpfreaks.com/topic/307714-couldnt-figure-out-how-to-fetch-values-in-this-query-need-help/page/2/#findComment-1561076 Share on other sites More sharing options...
shan2batman Posted September 24, 2018 Author Share Posted September 24, 2018 (edited) 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 Edited September 24, 2018 by shan2batman Quote Link to comment https://forums.phpfreaks.com/topic/307714-couldnt-figure-out-how-to-fetch-values-in-this-query-need-help/page/2/#findComment-1561077 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.