Hi, anyone up with sql? Trying to develop a query and can't quite get a join right ?

SELECT [Prefix] & [Subletter] AS ff, tblEPData2.TrackNum
FROM tblEPData2, tbl1964
WHERE ((([Prefix] & [Subletter]) Like "EP64*") AND ((tblEPData2.TrackNum) Like "B*"))
ORDER BY [Prefix] & [Subletter];

But I need to output another table containing ff. (So my whole approach may be quite wrong)

Thanks