Join on a join on a join????!!!!!!

[Dineedshelp]

Hi,

I have two tables that I need to join together, table a and table b. (Thats the easy bit!!!). Within table a and b I have three fields clientref, locationref, ward ref. All the records within my table have only one of either clientref, locationref, wardref. These are the only three columns that link the tables.
How can I join them together?
Could I use an if statement?

Help, its Friday!!!!!!

 

[dbomrrsm]

select xyz
from taba,tabb
where a.clientref = b.clientref
or a.locationref = b.locationref
or a.[ward ref] = b.[ward ref]

[blue]DBomrrsm[/blue]

 

[Dineedshelp]

Not working, comes back with the error:
invalid name for locationref and wardref

 

[dbomrrsm]

can you post your code and the full error message

[blue]DBomrrsm[/blue]