>Hello Jim
>
>I think this will do the trick:
>
>Select tableone.horsename, ;
> tableone.acctnumber, ;
> tableone.syndicatenumber, ;
> tabletwo.acctname, ;
> tablethree.syndicatename ;
> from tableone LEFT OUTER JOIN tabletwo ON Tableone.acct_no = tabletwo.acct_no ;
> LEFT OUTER JOIN tablethree ON tableone.syndicatenumber = tablethree.syndicatenumber ;
>WHERE tableone.yearbred = 2001
>
>HTH
>Mike
Thanks Mike,
Here's the select,
***begin select
select master.p_s_c, master.acct_no as acct_no, master.name, master.booked_to, ;
master.yr_bred, master.syn_acct as syn_acct, accounts.fname as acctfname, ;
accounts.lname_comp as acctlname, syn_mem.fname as synfname, ;
syn_mem.lname as synlname from master left outer join accounts ;
on master.acct_no = accounts.acct_no left outer join syn_mem ;
on master.syn_acct = syn_mem.syn_acct where ;
master.booked_to = 'arturo' and yr_bred = 2001
***end select
Works fine, I appreciate your help.
Jim