SQL Select table1.columa as table1.columb

Posted by Lukas Oppermann on Stack Overflow See other posts from Stack Overflow or by Lukas Oppermann
Published on 2010-04-08T19:52:15Z Indexed on 2010/04/08 20:03 UTC
Read the original article Hit count: 359

Filed under:
|
|
|

I am working on a database join and I want to do the following:

Select tabel_one.id, 
       tabel_one.title, 
       tabel_one.content, 
       table_two.value as table_two.key 
  from tabel_one 
  Join table_two ON table_two.id = table_one.id ....

The Important part is:

table_two.value as table_two.key

Is there a way this could work?

© Stack Overflow or respective owner

Related posts about sql

Related posts about mysql