I have 4 tables:
Companies and Sectors tables will updated about once a month while CompaniesData and SectorsData will be updated daily so in my understanding I can't have only 2 tables since it would be a lot of unnecesary data every day. For instance:
SectorID, CompanyID, CompanyName, CompanyLinkProfile that belongs to the first 2 tables it always will be the same but other kind of information like TodayPrice, TodayTrend will be added daily.
Having only 2 tables will result in some kind of (see atached image)
CompanyID | SectorID | CompanyLinkProfile | TodayPrice | TodayTrend
45 | 14 | http:// link to any | $30 | Up
45 | 14 | http:// link to any | $35 | Down
45 | 14 | http:// link to any | $50 | Up
*Note only the 2 last columns are changing.
Using 4 tables and with this query is not giving me any results despite the fact that there is data in every table:
SELECT [login to view URL]
, [login to view URL]
, [login to view URL]
, [login to view URL]
FROM Companies AS c
JOIN Sectors AS s ON [login to view URL] = [login to view URL]
JOIN CompanyPriceRS AS cprs ON [login to view URL] = [login to view URL]
JOIN SubSectorsBPIsData AS ssbpi ON [login to view URL] = [login to view URL]
If I remove the last JOIN line then i get proper result but that's not what i want. I need the 4 tables involved. I have added indexes to almost any column so i think that's not the problem.
Figure out why this query is not working, fixing it and tell me what you did.
Or figure out another way of handle this issue and explain it to me. I'll only reply proposals from people who actually read this project and contact me with keyword: lucino
Easy, fast and simple money :)
Thanks for your time
lucino Hi! What is wrong with your query result? Do you get an extra rows or lose some rows? If you lose some rows, I suppose you need to change join type. Can you provide db dump? Or, better, remote access to Plus
14 freelance font une offre moyenne de $25 pour ce travail
Respeceted Sir, lucino Scope of the work will be to fix the sql query to show data. Am I right? Regards Pankaj Garg
Hi sir, I have best experience and skills in MySql. I have read carefully and very interested. I want to do it.
hi lucino, I have checked attached images and there is a problem in your query that you have to right join to make the query perfect. let me know if you are interested. send me sql files , i will write query f Plus
I have being working as php developer since 8 years in which 4 Years I have being working as joomla developer. I have also worked in Magento, cake php, wordpress, prestashop, boonex, osccomerce, opencart ect websites w Plus
Hi! could you show me your source and db? I've read your demands carefully and I have a full experience for website and mysql. if you give me a chance, i'll do my best. I am a developer with Mobile and Web Expert with Plus
lucino hi, did you try inner join here? i think the only issue is may be there is no match of sectorid in these to table 1)Symbol 2)SubSectorsBPIsData
I can work on this immediately, your description is very much detailed, however I would much appreciate if you could provide a sample mysql dump file so I could provide a better explanation as to why your query provide Plus
Feel fee to contact me for .Shoot me message to discuss further more details .We provide the comments,images,videos,demos and live sessions in order to help the [login to view URL] payment only after the work [login to view URL] y Plus
Hello lucino, I have read the instructions and I have experience with mysql and I can easily check and fix your query. Let me know if you have any questions. Thanks Dinesh Chand
lucino Hi, I am a Full stack developer in Microsoft technologies. My area of expertise is web application development (asp.Net web forms, MVC, classic ASP), web services (SOAP & RESTFul), MySql & Sql Server as ba Plus
Hi, I have read your requirements, I will definitely help you in configurations and setting up the Project as per your requirements. If you can give opportunity then I will do this job for you. Have a look at my exp Plus
Hello, This is Alisa - an advanced PHP programmer. Can we do quick chat right now so that we can discuss the project briefly? Here are some PHP based website that required a high level of customization from our por Plus
I am good in mysql database and devops engineering Please let me know if you are good to award this project to me