Data modeling

ritumishra01 — Fri, 15 Nov 2024 21:30:42 GMT

I have three tables

idea

idea_number,

Dmnd_number,

idea_startdate ,

idea_enddate,

idea_state

demand

Dmnd_number,

prj_number,

Dmnd_startdate ,

Dmnd_enddate,

Dmnd_state

project

Prj_number,

Prj-startdate ,

Prj_enddate,

Prj_state

i have three tables and they all have state which holds the status value (if idea state is 1 then draf 2then submitted)

so o for other table as well.

but if i join state it is giving me duplicates i want to join three table and get the status .

its like i need idea , demand and projecf which are associated in a single row and the latest status and the latest start and end date

Re: Data modeling

BrunPierre — Tue, 08 Aug 2023 19:25:34 GMT

Hi, Your question is somewhat unclear.

cristianj23a — Tue, 08 Aug 2023 20:43:33 GMT

Hi, I don't quite understand your query, could you please give us more details.

Regarts.