Dibatalkan

SQL query to gather information from 2 tables

Hello!

We are displaying data from a mySQL 5.1 database on our website. In the past we used an SQL query to gather the following fields from a table:

- first_name

- city

- state

- profession

- date_of_birth

where the "status" field of the user was confirmed.

In the past this was easy because all the users were stored in one table (wp_net_user), and 1 subscriber's data was stored in one line (first_name, state, city...) so it was easy to print out in a horizontal order with a MySQL query.

I don't know why but this was changed by the management and users and their fields are now stored in 2 different tables: wp_net_subscribers (first name, last name, status) and wp_net_custom_fields (city, state, profession, date_of_birth).

So we need an SQL query which shows these in a horizontal line:

from table "wp_net_subscribers":

- "first_name" field,

- "status" field

from table "wp_net_custom_fields" corresponding to the id of the subscriber:

- "city" field,

- "state" field,

- "profession" field,

- "date_of_birth" field

where the status is "subscribed" or "unsubscribed". So both statuses should be displayed. Or you can exclude "unconfirmed" status.

Kemahiran: Pentadbiran Pangkalan Data, Pengaturcaraan Pangkalan Data, MySQL, SQL

Lihat lebih lanjut: write sql query joins tables example database uses, complex sql query multiple tables, write sql query parent child relation tables database, sql server gather 2000 collation information, sql query tree view parent child tables, sql query filter tables, design sql query forum tree, sql query find number child elements, specialise sql query, getafreelancer message sql query help needed, sql query tree children, sql query tree structure, sql query child child, asterisk call forward database sql query, sql query tree structure records

Tentang Majikan:
( 1 ulasan ) Komarno 2, Slovakia

ID Projek: #15814797

Dianugerahkan kepada:

€16 EUR dalam sehari
(10 Ulasan)
3.2

55 freelancers are bidding on average €21 for this job

ITservice

Will create single query using both the tables and show in a row. Relevant Skills and Experience I have 15+ years of experience. Proposed Milestones €34 EUR - Project milestone Send me both tables structure.

€34 EUR dalam sehari
(68 Ulasan)
6.7
Paznek

Can you try : select a.first_name, [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], b.date_of_birth from wp_net_subscribers a inner join wp_net_custom_fields b on [url removed, login to view] = [url removed, login to view] and status <> 'unconfirmed'; Relevant Skills a Lagi

€20 EUR dalam sehari
(14 Ulasan)
5.9
€24 EUR dalam 0 hari
(21 Ulasan)
5.5
mail2vimalarora

Hi..having gone through your project details on SQL query, I can help you with quick and efficient solution. I am working professionally on sql and database tasks and can handle well. Relevant Skills and Experience Te Lagi

€19 EUR dalam 0 hari
(55 Ulasan)
5.4
prakash2813

Hi there, This is an easy job for me. I can write join query to get expected output. Message me, we can do over team viewer as well. Relevant Skills and Experience I have strong knowledge in plsql, pivot tables, dynam Lagi

€30 EUR dalam 0 hari
(19 Ulasan)
5.0
softcarve

Hi there, My name is Manish. I would like to write sql query to get details from wp_net_subscribers and wp_net_custom_fields in one line. please get in touch to discuss more. Relevant Skills and Experience I have good Lagi

€9 EUR dalam 0 hari
(35 Ulasan)
5.1
€30 EUR dalam 3 hari
(19 Ulasan)
5.1
€23 EUR dalam sehari
(13 Ulasan)
4.8
€14 EUR dalam sehari
(57 Ulasan)
5.4
kmpal

Hi, I am an experienced developer with vast experience in .NET, MVC, SQL, JS, TS, J-Query available for this project. I am full time freelancer available througout the day. Best Regards Khalid. Relevant Skills and Lagi

€29 EUR dalam sehari
(7 Ulasan)
3.4
€30 EUR dalam sehari
(2 Ulasan)
3.1
naveenlalwani77

Greetings! My name is Naveen lalwani and i am an expert in wordpress, php, sql, css, js. I would love to have the opportunity to discuss your project with you. Relevant Skills and Experience I have 4 years of experien Lagi

€9 EUR dalam sehari
(7 Ulasan)
3.1
nraghuvanshi93

I know why this was done, for database optimization, it is a good process, and I can provide you a join query which can give you joined result from both table, its normalization, and its good for db. Relevant Skills Lagi

€12 EUR dalam sehari
(2 Ulasan)
3.0
jayesh793

We have a few questions about your project, please send us message so that we can discuss more. Relevant Skills and Experience Relevant Skills and Experience Some of my skills are mentioned below:HTML5, CSS, Bootstrap Lagi

€39 EUR dalam sehari
(4 Ulasan)
2.8
€23 EUR dalam sehari
(5 Ulasan)
2.7
abubakar4248

Hi I am a professional software engineer I have +3 years experience in this field I have lots of expertise in database development using SQL server, MySQL and Oracle I will provide quality work according to your requir Lagi

€10 EUR dalam sehari
(2 Ulasan)
2.2
Lultu

A simple join should do Relevant Skills and Experience SQL, MySQL, php Proposed Milestones €14 EUR - On completion Hope to chat

€14 EUR dalam sehari
(5 Ulasan)
2.4
€24 EUR dalam sehari
(4 Ulasan)
2.4
laxmanpatel46

able to stat and finished now Relevant Skills and Experience php ,sql Proposed Milestones €23 EUR - for more details conatct please tahnks

€23 EUR dalam sehari
(4 Ulasan)
2.1
ahmeddarwish123

Hello I will do it in a day It's a piece of cake for me. I am [url removed, login to view] contact me. Thanks Relevant Skills and Experience Database Administration, Database Programming, MySQL, SQL Proposed Milestones €23 EUR - i Lagi

€23 EUR dalam sehari
(1 Ulasan)
1.5