Hello,

Not been solved and I am in trouble still.

Table: bulk_movement

Field: movement_id and movment_number

Table: bulk_product

Field: movement_id

bulk_movement table:

movement_id movement_no

54332 ...

Did like this (these are tho one's I'm having issue with)

SELECT bm.*, '#', bp.*

FROM [VEMA-FACS1].FUELFACS.dbo.bulk_movement AS bm

INNER JOIN [VEMA-FACS1].FUELFACS.dbo.bulk_product AS bp

ON bp.bulk_movement_id = bm.bulk_movement_id

WHERE bm.bulk_movement_id = '54332' or bm.bulk_movement_id...

I commented out all joins except for

FROM[VEMA-FACS1].FUELFACS.dbo.bulk_movement AS bm

INNER JOIN[VEMA-FACS1].FUELFACS.dbo.bulk_product AS bp ON bp.bulk_movement_id = bm.bulk_movement_id

and result is (same as before)

201103302011 MC 01 497883100 859700 ...