I need to link 3 ^&*%^* tables ... Easy right?

table1 fields  name,workid,homeid   example  "Steven",34,12

worktable fields workid, description example  34, "Janitor"

21, "CEO"

homes fields homeid , address                       54, "119 Daris"

12, "23 Park Avenue"

How the hell do select "Steven","Janitor","23 PArk Avenue" in a sql

Tried this
Select  table1.name,worktable.description,homes.address table1 inner join
worktable on table1.workid = worktable.workid inner join homes on
table1.homid = homes.homeid

and about a million other ways... Man i am missing foxpro right now!

--
Craig Ison

Remember if your Going to Kneel Make Sure its the Pope And Not President

Remove The MR from my e-mail Address For Replying

Try this (The code is freehand. Obviously, I can't test it without creating
tables that match yours):

Select  table1.name,worktable.description,homes.address FROM (table1 inner
join worktable on table1.workid = worktable.workid) inner join homes on
table1.homid = homes.homeid

Lee Weiner
weiner AT fuse DOT net

select
table1.name,
worktable.description,
homes.address
from
table1,
worktable,
homes,
where
worktable.workid = table1.workid
and homes.homeid = table1.homeid
and table1.name = 'Steven'

 Mike