Subject | Re: [firebird-support] Using unions |
---|---|
Author | Aage Johansen |
Post date | 2004-02-03T20:54:13Z |
On Tue, 3 Feb 2004 20:19:46 +0000 (UTC), rajsubramani wrote:
1. Cast the '' to the type of "condition"
2. Use aliases always when doing joins
3. Use explicit joins (don't do it in the WHERE clause)
--
Aage J.
> I'm using firebird 1.0.The type of the empty string ('') is different from "condition".
>
> When I try to do
>
> select book_id, price, '' as condition
> from Book
> UNION
> select bk.book_id, price, condition
> from Stock sk, Book bk where
> bk.book_id = sk.book_id
>
> I keep getting
> SQL error code = -104
> Invalid command
> Data type unknown
>
1. Cast the '' to the type of "condition"
2. Use aliases always when doing joins
3. Use explicit joins (don't do it in the WHERE clause)
--
Aage J.