Terminé

*Simple/FastProject* Figure out why JOINING 4 tables doesn't show results in mysql

I have 4 tables:

Companies

Sectors

CompaniesData

SectorsData

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.

PROBLEM:

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.

YOUR TASK:

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

Compétences : Administration de Bases de données, Programmation de bases de données, MySQL, phpMyAdmin

en voir plus : mysql workbench result grid not showing windows, mysql workbench show result grid windows, mysql workbench show result grid mac, mysql workbench not showing results windows, mysql result grid missing, result grid not showing mysql, mysql workbench 8.0 result grid not showing, mysql workbench show result grid, chronoforms doesn`t send email, virtuemart doesn`t work move hosting server, explorer object doesn`t support property method, joomla administrator menu doesn`t work mootools, simple stick figure, simple stick figure art, simple graphic figure, simple stick figure drawings, simple stick figure animation, i need simple dynamic app with 4 screen, android sdk installation doesn t find jdk, freelancer com doesn t work

Concernant l'employeur :
( 4 commentaires ) San Salvador, Malta

Nº du projet : #18720448

Décerné à:

IceGlance

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

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(0 Commentaires)
0.0

14 freelance font une offre moyenne de $25 pour ce travail

WebInfoSolutions

Respeceted Sir, lucino Scope of the work will be to fix the sql query to show data. Am I right? Regards Pankaj Garg

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(71 Commentaires)
6.8
kipdev13

Hi sir, I have best experience and skills in MySql. I have read carefully and very interested. I want to do it.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(26 Commentaires)
5.9
phpprogramming

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(101 Commentaires)
6.2
articontech

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(38 Commentaires)
5.5
kkc1985612

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(6 Commentaires)
4.7
soshiv

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(20 Commentaires)
4.6
dnplugins

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(14 Commentaires)
3.6
RushService

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(3 Commentaires)
2.5
dineshchand73

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(8 Commentaires)
2.3
deepthi2889

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
1.1
leenaanthony1992

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
AlisaJeff

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
goodwork20k

I am good in mysql database and devops engineering Please let me know if you are good to award this project to me

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0