create table A (AID integer);
  insert into A values (42);
  create table B (BID integer);
  create table X (i integer);

  select 1
  from A, X
  join B on AID = BID