Distinct but still repeated data shown - databases
This is a discussion on Distinct but still repeated data shown - databases ; Need some of your advice here. I would like to distinct 3 tables in one query. Example of the table are: Table A: TABLE_INFO Table B: TABLE_BATCH Table C: TABLE_FLOw Table A consist of: Tab_id, Table_name Table B consist of: ...
![]() |
| | LinkBack | Thread Tools | Display Modes |
|
#1
| |||
| |||
| Example of the table are: Table A: TABLE_INFO Table B: TABLE_BATCH Table C: TABLE_FLOw Table A consist of: Tab_id, Table_name Table B consist of: Tab_id, Table_batch_step, Batch_server_id, Table_name, Filename, Batch Table C consist of Tab_id, table_batch, flow_step, From_drive, To_drive, Command, From_path, To_path SELECT distinct A.TAB_ID, A.TABLE_NAME, B.TABLE_BATCH_STEP, B.BATCH_SERVER_ID, B.FILENAME_PREFIX, B.BATCH_FILE, C. TABLE_BATCH, C.FLOW_STEP, C.FROM_MAP_DRIVE, C.TOP_MAP_DRIVE, C.COMMAND, C.FROM_PATH, C.TO_PATH1 FROM TABLE_INFO A, TABLE_BATCH B, TABLE_FLOW C WHERE A.TAB_ID=B.TAB_ID AND B.TAB_ID=C.TAB_ID AND A.TABLE_NAME='DSP_ISI_01' ORDER BY C.TABLE_BATCH, B.BATCH_FILE, B.TABLE_BATCH_STEP, B.BATCH_SERVER_id The problem: I face repeated of data although i put "distinct" in the start of the query. Can anyone help? If you need more info kindly let me know. |
![]() |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| is there any alternate query is available avoid repeated recordwithout using distinct | Database Administrator | mysql | 0 | 11-05-2008 01:41 AM |
| fcmsutil / ioscan give differing fc disks | Database Administrator | hp-hpux | 1 | 10-02-2008 07:32 PM |
| Unnecessary DISTINCT with ROW_NUMBER | Database Administrator | sqlserver-programming | 8 | 05-30-2008 09:58 AM |
| Re: [GENERAL] SELECT DISTINCT ON and ORDER BY | Database Administrator | postgresql | 0 | 03-28-2008 12:03 PM |
All times are GMT -4. The time now is 01:41 PM.




Linear Mode
