Search results
-
B
Multiple table SELECT queries in one statement?
SQL = "SELECT HR.Persno, HR.[First names], HR.[Last name], HR.[E-mail address], HR.[ ID], HR_1.[First names], HR_1.[Last name], HR_1.[E-mail address], COLevels.[CO LEVEL], HR.[ 1 ID], HR_2.[First names], HR_2.[Last name], HR_2.[E-mail address], COLevels_1.[CO LEVEL ] " & _ "FROM (((HR LEFT JOIN... -
B
Multiple table SELECT queries in one statement?
SELECT TableA.Data , TableAA.Data, TableB.Data, TableBB.Data, TableC.More FROM (((TableA LEFT JOIN TableA AS TableAA ON TableA.OtherData = injectedValue) TableB LEFT JOIN TableB AS TableBB ON TableB.OtherData = injectedValue") TableC ON TableC.OtherData = injectedValue) Hi... -
B
Multiple table SELECT queries in one statement?
ahh, thanks. I thought I may have to nest the where statement within the first part of the query. I'll try again in work tomorrow. Regards Bug -
B
Multiple table SELECT queries in one statement?
many thanks Rookie, it now makes more sense. One thing I'm unsure about is where abouts to place the 'where' for the table join not ON. Many thanks Bug -
B
Multiple table SELECT queries in one statement?
Hi there, I'm fairly new to access and am finding some of the table joins a bit tricky. I have a design view statement defined that queries multiple tables for information based on the contents of another table. I now need to query the tables from within an excel database. If I build the...