Is it possible to include dual table in a join query

Question

Is it possible to include the DUAL table in a join query ?

Can anyone give me an example which includes the SYSTIMESTAMP from dual table.

Answer 1

One common use (for me) is to use it to make inline views to join on...

SELECT
  filter.Title,
  book.*
FROM
(
  SELECT 'Red Riding Hood'  AS title FROM dual
  UNION ALL
  SELECT 'Snow White'       AS title FROM dual
)
  AS filter
INNER JOIN
  book
    ON book.title = filter.title

[This is a deliberately trivialised example.]