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
Hi, here are my tables
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,
shift
}
tabl
