Hi,
I'm trying to build a single sql statement out of the 2 statements below but I have no idea how, or even if it is possible to do. Can anyone enlighten me?
SELECT Accounts.[Name], Accounts.[Address], Accounts.[Phone]
FROM Query1 INNER JOIN Accounts ON Query1.[Members] = Accounts.[Name];
The following is Query1:
SELECT Members.[Members]
FROM Accounts INNER JOIN Members ON Accounts.[Account_ID] = Members.[Account_ID]
WHERE (((Accounts.[Account_ID])=2586));
As you can see, I've managed to create the queries to do it but I have not been able to put them together. Is it possible?
Thanks for any help you can provide!
I'm trying to build a single sql statement out of the 2 statements below but I have no idea how, or even if it is possible to do. Can anyone enlighten me?
SELECT Accounts.[Name], Accounts.[Address], Accounts.[Phone]
FROM Query1 INNER JOIN Accounts ON Query1.[Members] = Accounts.[Name];
The following is Query1:
SELECT Members.[Members]
FROM Accounts INNER JOIN Members ON Accounts.[Account_ID] = Members.[Account_ID]
WHERE (((Accounts.[Account_ID])=2586));
As you can see, I've managed to create the queries to do it but I have not been able to put them together. Is it possible?
Thanks for any help you can provide!