Constants in joins

rbuser

Hi

Is it possible to declare a constan in joins? I would like to use joins like
this:

SELECT *
FROM A INNER JOIN B ON (A.X = B.X AND B.Y = 'ALPHA')

thank you

Ferenc Lendvai

digitalmetaphors

RB doesn't support every single feature found in the many different flavors
of SQL, nor all possibilities of standard SQL syntax. Sorry, but you'll have
to edit the SQL as text to enter the join expression constant manually and
lose the query tools support for this query.


Cheers,

Jim Bennett
Digital Metaphors

digitalmetaphors

We support the SQL 2 standard as much as we possibly can and support all the
different databases that we can. However, this isn't supported. Can you try
using the WHERE clause (search criteria in DADE) to create this dataset?


Cheers,

Jim Bennett
Digital Metaphors