Hi Naheed !
I could not clearly understand your requirement , but here is a sample of possible inner join . You can change it accordingly . While i assumed Arifdb.p.NORTH , Arifdb.a.AVAILABILITY_N As Table .


SELECT Distinct
COLUMN1, COLUMN2, COLUMN3, COLUMN4, COLUMN5, COLUMN6, COLUMN7, COLUMN8,
COLUMN9
FROM
Arifdb.p.NORTH N
INNER JOIN Arifdb.a.AVAILABILITY_N A ON A.Column6 = N.COLUMN12
WHERE



-----Messaggio originale-----
Da: Sultana, Naheed [mailto:naheed.[Email Address Removed] mercoledì 20 novembre 2002 16.27
A: LazyDBA.com Discussion
Oggetto: Need help with a JOIN Query!


Hi All,

I need help with a Join Query,I think I am wrong somewhere which I am unable
to figure out.Pls help me on this.

SELECT DISTINCT

COLUMN1, COLUMN2, COLUMN3, COLUMN4, COLUMN5, COLUMN6, COLUMN7, COLUMN8,
COLUMN9

FROM Arifdb.p. NORTH , Arifdb.a. AVAILABILITY_N

ON COLUMN 6= COLUMN12

WHERE COLUMN 10, COLUMN11, COLUMN12, COLUMN 13;

TIA
Naheed

MS Sql Server LazyDBA home page