Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raydenl
Starting Member
16 Posts |
 Posted - 2004-03-28 : 16:22:48
|
| Anyone know how to get this quesry to work in MS Access?It tells me this Join expression is not supportedSELECT P1.FirstName + IIF(ISNULL(P2.FirstName), '', ' & ' + P2.FirstName), C.FlatHouseNo, C.StreetName, C.TownCity FROM (Contact C INNER JOIN Person P1 ON (C.ContactID = P1.ContactID)) LEFT JOIN Person P2 ON (C.ContactID = P2.ContactID AND P1.MemberID <> P2.MemberID) |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2004-03-28 : 17:33:55
|
| What is the exact error message you are getting? in the design grid, certain joins cannot be displayed -- is that what you are getting for an error? even if so, the query should still execute only you must edit it in the SQL view.- Jeff |
 |
|
|
|
|
|
JOIN problem