Project translated automatically. Log in or register, to view the original There is a SQL request. 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?

Proposals 1 Rejected 1 Discussions 2

Aleksey Maslov

Winning proposal

22 0

Projects 22
Rating -
Rating 591

Budget: 300 RUB Deadline: 1 day

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₽

Vyacheslav Zinin 31 August 2019

Что за СУБД?
Используйте left join

Yura Kuruts 31 August 2019

SELECT * FROM xf_node
left join xf_forum on xf_node.node_id = xf_forum.node_id
WHERE parent_node_id = $categoryId

Add Comment

Current freelance projects in the category Databases & SQL

Senior AI Systems Architect (Project Lead) Needed to Complete an Existing Unfinished Global Service

Gaming Apps 17 proposals 3 August

Not specified
Development of the CRM module "Requests" in custom 1C (bus center)

Client Management & CRM 19 proposals 31 July

Not specified
Support for Samotur and its servers

17 proposals 27 July

22 USD
Cleaning the client database in SIMLA CRM: phones, duplicates, cities

Client Management & CRM 42 proposals 27 July

179 USD
Client registration and visit confirmation system (MVP)

Web Programming 162 proposals 10 July

Not specified

Vladislavs Sipov
Riga, Latvia

Projects 94
Rating -
Rating 1 020

You need to make a SQL request with a combination

Client's review of cooperation with Aleksey Maslov

You need to make a SQL request with a combination

5.0

Vladislavs Sipov

Freelancer's review of cooperation with Vladislavs Sipov

You need to make a SQL request with a combination

5.0

Aleksey Maslov

Aleksey Maslov

Proposals are currently absent

Proposals concealed

Current freelance projects in the category Databases & SQL

Senior AI Systems Architect (Project Lead) Needed to Complete an Existing Unfinished Global Service

Development of the CRM module "Requests" in custom 1C (bus center)

Support for Samotur and its servers

Cleaning the client database in SIMLA CRM: phones, duplicates, cities

Client registration and visit confirmation system (MVP)