Query - Joins in Design View

[solargovind]

Hi,

I am facing some eproblem in writing SQL query.

Hence, Can anybody suggest me how to assign Joins (Inner join,Outer join,Left join,Right join etc.,) in Query's Design View....?

For example,

From Stud_Table to Stud_Marks_Table What could be a join while Dragging ...?

Suppose, If Stud_id from Stud_Table is linked to Stud_Marks_Table's Stud_id, what could be a join created..?


Assume that all are linked with Right side,left side, bottom side,Top side by the way of Dragging. In this case what kind of Joins are created...?

Can anybody clear my doubt..?

Thanks in advance.

ngr.

[Rabbit]

Every join defaults as an INNER JOIN. To change the join type, click the line connecting the two fields or go to SQL View.

[NeoPa]

If you're curious about what SQL is being produced you can select SQL View from the View menu and review all the SQL created.