#8 Error using select

closed
nobody
None
5
2003-12-05
2003-04-22
Anonymous
No

Can't execute a select using two tables that have two
fields with the same name.

Example:

select * from A, B

if A has IdB, C
and B has IdB, D

Discussion

  • Nobody/Anonymous

    Logged In: NO

    You might try renaming the columns on the select statement.
    For example:
    SELECT a.Hi, a.How, a.Are, a.IDB AS You, b.IDB as YouTwo,
    b.OK FROM A,B

     
  • Manuel Lucas Viñas Livschitz

    • status: open --> closed
     
  • Manuel Lucas Viñas Livschitz

    Logged In: YES
    user_id=406263

    Use aliases.

     

Log in to post a comment.