Data modeling

[ritumishra01]

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 

[BrunPierre]

Hi, Your question is somewhat unclear.

[cristianj23a]

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

Regarts.