Writing An Sql Statement From Selecting Records From Two Files Using

1.	Writing An Sql Statement From Selecting Records From Two Files Using Single Statement And Nested Select Statement.
Answer» USING SINGLE STATEMENT. SELECT * FROM FILE1, FILE2 WHERE FILE1.FLD1 = FILE2.FLD1 Using Single statement. SELECT * FROM FILE1, FILE2 WHERE FILE1.FLD1 = FILE2.FLD1

Writing An Sql Statement From Selecting Records From Two Files Using Single Statement And Nested Select Statement.

Answer»

USING SINGLE STATEMENT.
SELECT * FROM FILE1, FILE2
WHERE FILE1.FLD1 = FILE2.FLD1

Using Single statement.
SELECT * FROM FILE1, FILE2
WHERE FILE1.FLD1 = FILE2.FLD1