Creating view

  • Resolved davitabile

    (@davitabile)


    4 years, 7 months ago

    Hi Peter,
    first of all thanks a lot for your work and support.
    I’m pretty new in the fiels.
    I have created a project “gestione verbali” with a parent table named vrb_new_vrb and a child one named vrb_new_arg. I have setted the 1:n relationship in the repository and I’m able to enter in the vrb_new_vrb and insert new records in vrb_new_arg.
    Now I would like to create a summary table dislaying for each record in vrb_new_vrb the child records in vrb_new_arg.
    I suppose I should create a join table to obtain a view. I have tried importing a script in data explorer I have modified from one contained in your SAS demo:

    CREATE VIEW vrb_summary AS select vrb_new_vrb.vrb_ID AS Verbale n.,vrb_new_vrb.vrb_titolo AS Ogetto:,vrb_new_vrb.vrb_data AS data verbale,vrb_new_arg.arg_ID AS argomento n. from (vrb_new_vrb left join vrb_new_arg on (vrb_new_vrb.vrb_ID = vrb_new_arg.vrb_ID)));

    However, when I run it nothing happen.

    Could you help me with this?

    Thanks in advance

    Daniele

Viewing 4 replies - 1 through 4 (of 4 total)

  • I see 2 opening brackets and 3 closing? (( )))?

    – Jack

    Thread Starter davitabile

    (@davitabile)

    Hi Jack,
    thanks for your suggetion.
    I have fixed it, however it still does not work…
    I’m working on it anyway
    thanks again
    Daniele

    Thread Starter davitabile

    (@davitabile)

    Hi Jack and Peter I have solved!
    There were several error. Here is the correct statement

    CREATE VIEW vrb_summary AS select vrb_new_verb.vrb_titolo AS TitoloVerbale,vrb_new_arg.arg_titolo AS TitoloArgomento from (vrb_new_verb left join vrb_new_arg on ((vrb_new_verb.vrb_ID = vrb_new_arg.vrb_ID)));

    Thanks

    Daniele

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Daniele and Jack,

    Great you solved it while I am on holiday! ??

    Thank you Jack!!!

    Best regards,
    Peter

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Creating view’ is closed to new replies.