simple view

[jbreusch]

Hi guys,
please don't start laugh but I'm not an SQL developer. I have get a request to create a view which should list user which have completed a renewal of certification. There are two tables involved and user could be in one or in both.
The variables are equal in both table.
user_id
certification_id
status_id
I get it work with one table but not with both.
I would thank you in advance for your help.
JB

[Scorby]

What is the structure of the two tables involved in the query ? You only seem to have given one here.

[jbreusch]

I have found what I need. I have created 2 views and created an other one who unioned the result of both.
cheers

[tamilselvan]

Why 2 views?
One view with 2 tables is enough.

Tamil