SQL Dummy

[jim.margetts]

Hi,

I have two queries:

qReg:

SELECT tblRegionalExperience.ConsultantID, tblRegionalExperience.RegionID
FROM tblRegionalExperience
WHERE (((tblRegionalExperience.RegionID)=1));


qLang:

SELECT tblLanguageSkills.ConsultantID, tblLanguageSkills.LanguageID
FROM tblLanguageSkills
WHERE (((tblLanguageSkills.LanguageID)=1));


i have these joined together in qAll:

SELECT qLang.ConsultantID, qLang.LanguageID, qReg.ConsultantID, qReg.RegionID
FROM qLang INNER JOIN qReg ON qLang.ConsultantID = qReg.ConsultantID;

but i would like be able to write qAll without reference to qReg or qLang. my efforts so far have been hopeless any help much appreciated.