Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Questions about views
Hi!
I got several question on views
Let's say I have defined my view like this:
create sql view myview as select * from DB!Father ;
where id<=?cid;
union all;
select * from DB!sons where id=?cId
it works, but I want to show the records ordered by the field Id.
How can I do that?
How can I modify or establish certain settings or features for
this view when I can't open the view designer?
In case I want to insert records by this view, how can I define in
what table I am inserting the data? how do you handle these cases?
Thanks in advance
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement