I amnot sure I am defining this query correctly. Can you please look at it and tell me what I am missing:
select * from P pn
LEFT JOIN B at ON KEYS pn.bkId
where pn.bk in ( select cu.bk from B cu USE KEYS pn.bookId where cu.d == ‘LDN’);
I am trying to filter the B’s so that I only get P’s for B’s that meet the criteria. In sql you might write something like
select * from P where P.bk in ( select B.bk from B where B.d==‘LDN’)
Teh pn.bookId has the B document id.