You need to make a SQL request with a combination
3 USD Select * from xf_node, xf_forum WHERE parent_node_id = $categoryId
AND xf_node.node_id = xf_forum.node_id
It works correctly, except for one nuance.
So, in both tables (xf_node and xf_forum) there is the primary key node_id. If the xf_node table has node_id 107, and the xf_forum table has no such node_id, then the result does not come. Can it be corrected somehow?
Client's review of cooperation with Aleksey Maslov
You need to make a SQL request with a combinationIt did greatly! I will address.
Freelancer's review of cooperation with Vladislavs Sipov
You need to make a SQL request with a combinationA great customer. Operational work . thank you.
-
Winning proposal1 day3 USD
591 22 0 Winning proposal1 day3 USD
Good morning, I will write a Join request right now.
Do you need all the fields in both tables (*) or specific?
300 -- because -- The minimum budget of the project seafood should be not less than 100 or 300₽
-
SELECT * FROM xf_node left join xf_forum on xf_node.node_id = xf_forum.node_id WHERE parent_node_id = $categoryId
-
Current freelance projects in the category Databases & SQL
Heal the 1C configuration
111 USD
Configuration of CRM & ERP SmartCeiling (2.8.26.0) Protection via Registration Code. Registered until the end of the year. Databases & SQL ∙ 2 hours 45 minutes back ∙ 5 proposals |
Power BI
16 USD
The dashboard runs on a Google server, we need to transfer all logic + code Required skills: deployment of ETL processes on a Linux server + working with BigQuery and Postgre There is working code that runs on Google, where the database itself is, we need to transfer it to… Python, Databases & SQL ∙ 3 days 2 hours back ∙ 16 proposals |
Need a 1C specialist for refinements and development.I am looking for a 1C specialist for freelance collaboration. I am currently working with a contractor who provides support and maintenance for the 1C system. However, due to the contractor's workload, there is a need for prompt execution of additional tasks, improvements, and… Databases & SQL ∙ 5 days 2 hours back ∙ 11 proposals |
Restoring Instagram after a banOn March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 5 days 13 hours back ∙ 6 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 8 days 20 hours back ∙ 16 proposals |
Riga