Lengkap

SQL Help help me write a Select Query

See attached picture of the problem.

I need help writing a query that will be able to return this output.

The input is shown in green table, only has 2 columns.

I want a list of all the IDs and the original ID if that makes sense. Please see attached example.

The green table is a transactional table where one record is linked to the previous ID.

Please note, there could be hundreds unknown amount of links to previous records so need to think of an iterative or procedural way not just 3 nested select statements or something like that.

Please start your offer with the word purple so I know you have read this project description.

Thanks for your time and understanding.

Kemahiran: SQL, Oracle, MySQL

Tentang Klien:
( 69 ulasan ) Eight Mile Plains, Australia

ID Projek: #34366747

Dianugerahkan kepada:

MimiFL

Ok, first lets start with "purple" word. I believe you this can be solved relatively quickly, if you are interested, feel free to message me and i will show you a sample. The green table you have has pretty good struct Lagi

$25 AUD dalam sehari
(27 Ulasan)
4.3

25 pekerja bebas membida secara purata $42 untuk pekerjaan ini

nixtech

Hello Sir Can i have more detail? I am willing to start right away. Please check my profile for work and experience. Regards Hardeep.

$50 AUD dalam sehari
(145 Ulasan)
6.4
Truonggiang86

Purple!!! Hello there, I've seen your attachment, to write this kind of queries we should write a recursive query. Within Oracle we can use the connect by statement, within sql server we can use with statement to solve Lagi

$90 AUD dalam sehari
(51 Ulasan)
6.0
giaphung2k1

G'day I can do this project. I am a professional Linux and developer in PHP, Wordpress, Laravel , Javascipt, Vue.js, HTML5, CSS3 and jQuery. I can do this project. Please hire me. I think, You will contentment with Lagi

$10 AUD dalam 7 hari
(23 Ulasan)
4.4
kaindo2017

Hi, i am an expert in SQL script writing. I have a Bsc degree in computer science. Please consider for the task i will provide the best quality.

$50 AUD dalam 3 hari
(12 Ulasan)
4.4
jpdestudio

Hi,Dear client! I've read your post and I am ready to take up the task. I have rich experience in DB and I have various techs such as MySQL,Postgres,MongoDB etc. So I can do the job for sure. Please contact me if you a Lagi

$30 AUD dalam 2 hari
(7 Ulasan)
4.8
vw1514518vw

"Purple"..The SQL is Ready, Tested, Working as required, Check link for table data and query output:...... [login to view URL]

$50 AUD dalam sehari
(1 Ulasan)
3.9
SeasonedDveloper

Purple I am ready to start this job instantly according to your requirements. I would like to discuss the details with you via chat. Looking forward to hearing from you. Regards Daniyal

$20 AUD dalam sehari
(2 Ulasan)
3.7
b2btechnology20

Hello I am a good fit for this Job I have lots of experience in this sector. I have worked for many Client before on other platforms. Thank you in advance for your time and consideration. Thanks Mahesh Kumar

$20 AUD dalam sehari
(7 Ulasan)
3.1
SPARKtechBD

Since 2010 I am working on SQL database systems on MSSQL, Azure SQL or MySQL and ER diagram to design and build database systems. So more than 10(ten) years of experience in SQL. If you want a good delivery of work, th Lagi

$250 AUD dalam 3 hari
(7 Ulasan)
3.1
DanielMue

'purple' Hello dear customer, I'm a data scientist with knowledge in SQL and worked already with different databases. This looks like you need a solution with an recursive sql command. i can solve that SQL issue for Lagi

$100 AUD dalam 2 hari
(4 Ulasan)
3.2
(1 Ulasan)
1.7
denysdenysivanch

❤️ Hello. purple I have rich experience in SQL query. I've checked your attach image and I've fully understood your requirements. So i can writing query as you want. I'm sure I will complete your job perfectly. Please Lagi

$20 AUD dalam sehari
(1 Ulasan)
1.1
csuciu38

purple Hi! I can write that query for you. I have strong skills in MySQL and a long experience in programming. I am available and ready to start working. Thank you, CristinaS

$30 AUD dalam sehari
(1 Ulasan)
1.2
PadmajaKarekar

Purple I have created the query and output is same as what you are looking for. Just a single select used. Please message me so that I can share a screenshot of the output. Hello! I hope you are doing well. I hav Lagi

$15 AUD dalam sehari
(2 Ulasan)
1.2
yevheniiahorbun3

hello! I read your job detail carefully. I am ready to get started working immediately. I am confident in this job as I am a sql expert Looking forward to your positive reply.

$30 AUD dalam sehari
(0 Ulasan)
0.0
balbrad86

"purple" Hi, I have many experience in SQL. I'd like discuss about your project in detail. Looking for your reply.

$50 AUD dalam 7 hari
(0 Ulasan)
0.0
shahzaibrasool1

Hello, Hope you are doing great! I am a full-stack developer with 4+ years of experience in this field, I'll help you execute your project. I have the skill to execute all visual designs from concept to finalized engi Lagi

$20 AUD dalam 2 hari
(0 Ulasan)
0.0
PriyaRathore5766

Hello there, Having required knowledge in SQL and can deliver the required functionalities within given period of time

$10 AUD dalam sehari
(0 Ulasan)
0.0
fn7014971

Purple. Hello there. Hope you are good. I have gone through your requirements and i am sure i can help you in this project as i have vast experience in MYSQL database. I have written many such queries. Hope you will co Lagi

$13 AUD dalam sehari
(0 Ulasan)
0.0
MOUNISHNANDI

I have more than 7 years of real time experience as a Java developer. I have worked on Java 8, J2EE, Restful API, Microservices, Spring Boot, Maven, Unix, Autosys Job,JDBC,Cucumber and SQL.

$20 AUD dalam 7 hari
(0 Ulasan)
0.0