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
Hi, suppose I have two tables
table User
{
id integer,
name text,
address text
}
Table UserWork
{
userid integer references User(id),
work text
}
Suppose I have three users
idnameaddress
1 Tony main street
2 Peter Big ave
3 Richard Loop Blvd
An
Thank you for your post. To make things a little bit complicated:
Suppose I have another table UserInformation
UserInfomation
{
userid integer referenes user(id),
mothername text
}
I would like methername also appear in the final join. Suppose each
user must have a mothername.
Could yo
