|
View previous topic :: View next topic
|
| Author |
Message |
Amolondhe007
Warnings : 1
New User
Joined: 16 Apr 2007
Posts: 49
Location: Pune
|
|
|
|
I have 3 tables i want 1 column from each table and write it into 4 th table.
Write select statement for this? |
|
| Back to top |
|
 |
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
| Amolondhe007 wrote: |
| Write select statement for this? |
WRONG - The idea of the interview questions forum is for you to supply the answers and for the other forum members to comment upon them. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
What did you tell the interviewer?
IMHO, there is not enough of a question for an answer to be given.
I suspect this is another of the times when the intended question and the percieved question were not the same. . . |
|
| Back to top |
|
|
esaccy
Currently Banned
New User
Joined: 19 Feb 2005
Posts: 22
|
|
|
|
1) SELECT (A,B,C) FROM A.ATAB AND B.BTAB AND C.CTAB
2) CREATE A TABLE
3)INSERT THE VALUES SELECTED FROM THE FIRST QUERY.
HOPE THIS HELPS YOU |
|
| Back to top |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA
|
|
|
|
| Quote: |
| I have 3 tables i want 1 column from each table and write it into 4 th table. |
based on what criteria\Condition? What are keys of tables?
this question is incomplete\invalid else |
|
| Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA
|
|
|
|
| Quote: |
| HOPE THIS HELPS YOU |
Probably not if it doesn't encourage the poster to do a little research to make an attempt at the answer. See expat's post. |
|
| Back to top |
|
|
|
|
