I had a break through today.. very happy camper for DW.

I never was able to get my head around joining tables. Never knew what
to do in GL.

Today, in DW, advanced record set, I "got it"... I was able to say
tell me all the folks in this table that also live in this table....

so very good... I finally get it....

<http://forums.remodeling.hw.net/>SELECT directory.firstname,
directory.lastname, directory.company, directory.email,
directory.phones, leadership.title
FROM directory, leadership
WHERE directory.leadership_ID = leadership.leadership_ID

ok, for GL guys who are trying to go to DW, here's what I know...

use advanced in record set... then select from db 1 all the fields you
need... then add another db.. .and add those fields... then do a WHEN
and add second db


but here's the secret handshake... it says AND...

change AND to
tomorrow I'll add this to http://biz-comm.com/gl2dw/ with screen shots...

So, I hope this helps those in transition... screen shots tomorrow



--
Patrice Olivier-Wilson
888-385-7217
http://biz-comm.com


--
This list is a free service of LassoSoft: http://www.LassoSoft.com/
Search the list archives: http://www.ListSearch.com/GoLive/Browse/
Manage your subscription: http://www.ListSearch.com/GoLive/