Subject Re: intersect operation
Author Svein Erling Tysvær
--- In, "vbj34" <vbj34@y...> wrote:
> Hi, is it possible to perform set intersect operation with Firebird
> SQL? Thanks.

Is this a difficult way to ask whether it is possible to return only
records that exists in two separate tables? If so, it is simply a
matter of doing

SELECT <something>
FROM <table1>
JOIN <table2> ON <table2.field1> = <table1.field1>

or (depending on what you want)

SELECT <something>
FROM <table1>
WHERE EXISTS(SELECT * FROM <table2> WHERE <table2.field1> = <table1.

If this is not what you are asking, please rephrase your question so
that it is easier for us to understand.