Inner Join SQL Help

R

Ray Todd Jr

I'm trying to join two tables via SQL and am getting errors. Any help is
appreciated.

The tables:

taDEFENDANTS
DefendantsID PK
PropertyID FK
DefendantsNameID FK
DefendantType FK

TaDEFENDANTNAMES
DefendantsNameID PK
LastName
FirstName
MiddleName
Suffix

The SQL:

SELECT DISTINCT taProperty.PropertyID, CONCATENATE("SELECT FirstName & ' ' &
MiddleName & ' ' & LastName & ' ' & Suffix, DefendantsNameID FROM
taDEFENDANTNAMES INNERJOIN taDEFENDANTS ON
taDEFENDANTNAMES.DefendantsNameID=taDEFENDANTS.DefendantsNameID WHERE
PropertyID=" & taProperty.PropertyID & " AND DefendantTypeID=20") as
Property_Owner FROM taPROPERTY

The Error:

Run-Time Error: 3131
Syntax Error in FROM Clause
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Help 8
Report Query Difficulties 11
Concatenate Error Help 11
Query Criteria Question 2
Getting Multiple Owners Names for Single Pieces of Property 8
Concatenate WHERE Criteria Question 1
Opening form to a specific record 8
Query How To? 2

Top