Anyone plzz help me

Dear SSC, thanks for your fast reply. When i execute your query the rows repeats 3 times with each values of the 3 dimensions

INVOICEID------ITMNAME-----DIM1----------------DIM2-----------------DIM3------------------CMPY

SINV-0015------ORGMICRO----10:Ph Department---101:Ph Department---30000:Ph Department---baygt

SINV-0015------ORGMICRO----10:AB Dpt-----------101:AB Dpt----------30000:AB Dpt-----------baygt

SINV-0015------ORGMICRO----10:Multi-------------101:Multi------------30000:Multi-------------baygt

instead...

I need help to write a query for selecting from two tables.

I have 2 tables named ; sales and dimensions;

I need to write some select statement to bind two tables...