Help with simple MySQL Query?
-
I am using an INNER JOIN to return a table with two joined tables. The problem is that both tables have the identical field name called "id". How do I write a query that will return table1.id as id1 and table2.id as id2 and the rest of the columns as they normally are WITHOUT having to list all the columns one by one? To elaborate, I want to combine: SELECT table1.id AS id1, table2.id AS 1d2 FROM.... with SELECT * FROM to return the result set with all columns but with the id columns renamed.
-
Answer:
Well, you could try something like the following: select table1.*, table2.*, table1.id as id1, table2.id as id2 ... this of course will produce both the original id field for each table named as id, but then a second for each column named id1 and id2. Not sure about MySQL but just tested with Oracle and it works fine.
MK at Yahoo! Answers Visit the source
Related Q & A:
- How to convert sql query to Hibernate Criteria query?Best solution by Stack Overflow
- How to convert my SQL query to MS Access query?Best solution by Stack Overflow
- How to do a MySQL recursive query?Best solution by Stack Overflow
- How to write a query for PHP and MySQL?Best solution by Stack Overflow
- How to make a MySql query faster?Best solution by Stack Overflow
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.