Create a SQl request

Databases & SQL — incorrectly specified categories?

4 USD

Client's review of cooperation with Vladimir G.

Create a SQl request

4 USD

Everything went well. The executor made the right request and explained the reason.

5.0

Timur Timur

Reciprocal Feedback

28 September 2022

Freelancer's review of cooperation with Timur Timur

5.0

Project translated automatically. Log in or register, to view the original There are 2 tables. ps_customer and ps_address It requires what id_customer would draw the value of id_gender in the request. The query lacks the column id_gender that is in another ps_customer table. The request itself is now processing without a dop column like this. SELECT a.`id_address`, a.`firstname` AS `firstname`, a.`lastname` AS `lastname`, `address1`, `postcode`, `city`, cl.`id_country` AS `country` , cl. `name` as country From `ps_address` a LEFT JOIN `ps_country_lang` cl ON (cl.`id_country` = a.`id_country` AND cl.`id_lang` = 3) LEFT JOIN `ps_customer` c ON a.id_customer = c.id_customer WHERE 1 AND a.id_customer != 0 AND c.id_shop IN (1) AND a.`deleted` = 0 Tables in the archive

Proposals 1 Discussions 3

Vladimir G.

Winning proposal

72 0

Projects 62
Rating -
Rating 1 479

Budget: 200 UAH Deadline: 2 days

Hello to Timor.
Your project is interesting, I have been able to add the field.
Let’s find out that you’re wrong.

Current freelance projects in the category Databases & SQL

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

Gaming Apps 12 proposals 11:47

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 41 proposals 27 July

179 USD
Development of an analytical system with a dashboard

Enterprise Resource Planning (ERP) 43 proposals 20 July

Not specified

Timur Timur
Ukraine

Projects 29
Rating -
Rating 263

Timur Timur

Vladimir G.

Vladimir G.

Proposals are currently absent

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

Development of an analytical system with a dashboard