Thank you, But there seems to be syntax errors. Could you help?
Richard Broersma Jr wrote:
> > table name
> > {
> >id integer primary key
> >first_name text,
> >middle_name text,
> >last_name text
> > }
> >
> > table address
> > {
> >id integer primary key
> >number int,
>
Taking a second look. I see a few places I made a mistake. :-(
> CREATE VIEW your_view AS
^
> SELECT N.first_name,
>N.last_name,
>A.street,
>A.city,
>W.hour,
>
> FROM person P
> LEFT JOIN name N ON (P.namid = N.id)
^
> table name
> {
>id integer primary key
>first_name text,
>middle_name text,
>last_name text
> }
>
> table address
> {
>id integer primary key
>number int,
>street text,
>city text,
>state text
> }
>
> table work
> {
>id integer primary key
>hours text
