Join candidate not showing up

• 
  Hi there,
  
  
  The Products table *is* suggested, along with the other tables you have defined in the database. SQL Prompt does not force you to JOIN only to tables where a foreign key relationship exists since this would be far too restrictive for many users.
  
  Hope that helps.
  
  
  Thanks,
  Bart

  Bart Read January 03, 2007 06:54

  - 0 +
• 
  Okay, I badly phrased it.
  
  I confirm that it is suggested somewhere in the list.
  
  Can you confirm that it is not on top? I would expect if you type in join that the foreign tables are n1 candidates and so are on top.
  
  Thanks,
  
  Tom

  buckley January 03, 2007 11:36

  - 0 +
• 
  That's correct, it won't be at the top.
  Thanks,
  Bart

  Bart Read January 03, 2007 13:16

  - 0 +
• 
  Hmz this is a showstoper for me. Put it on the top pls

  buckley January 03, 2007 18:37

  - 0 +

Add comment

Please sign in to leave a comment.