Help In An Critical Query

[raj reddy]

TABLE1 (TOTAL 3 COLUMNS)


A B C







TABLE2 (TOTAL 3 COLUMNS )


D E F










DESCRIPTION : actually there were two tables and of 3 columns containing each



WHAT I NEED :


I need a SINGLE query in such a way that





I have to get all the values of TABLE2.F(column) where


{ TABLE1.C(column) [where i can hardcode this column value as "1"] = TABLE1.A(COLUMN)}



and where TABLE1.A(COLUMN) /**ie this output { TABLE1.C(column) = TABLE1.A(COLUMN)} **/ = TABLE2.D(COLUMN)


ANY DOUBTS REPLY TO ME

[rico16135]

I believe you need to read about JOIN
SQL Join