dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

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: ...


Home > Database Forum > Other Databases > databases > Distinct but still repeated data shown

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 10-06-2009, 05:41 AM
Database Newbie
 
Join Date: Oct 2009
Posts: 1
koel1984 is on a distinguished road
Default Distinct but still repeated data shown

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:
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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads

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.