#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Location
    Odessa-Munich
    Posts
    2
    Rep Power
    0

    ... where 'true';


    Hi2all,

    I would like to use following query in Firebird:

    select Table.v1, Table.v2 where 'true';

    Is it possible?
    If not, what alternative query can I use instead of that.

    Thank You in advance,
    Alexander
  2. #2
  3. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2002
    Location
    London
    Posts
    349
    Rep Power
    13
    where whats true?
    If you want to select all, then use select * from Table.v1, Table.V2
  4. #3
  5. Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Jun 2002
    Location
    Washington, DC
    Posts
    2,692
    Rep Power
    22
    Ya, as rendy said. You have yur query mixed up, you need to move the table(s) aound in the query and specify which columns you want to return or just return them all - then you need to add your condition WHERE something = true
    ~ Joe Penn
  6. #4
  7. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2003
    Location
    Odessa-Munich
    Posts
    2
    Rep Power
    0
    Originally posted by jpenn
    Ya, as rendy said. You have yur query mixed up, you need to move the table(s) aound in the query and specify which columns you want to return or just return them all - then you need to add your condition WHERE something = true
    Ok, Thank You

IMN logo majestic logo threadwatch logo seochat tools logo