create a relation between 2 tables using a third table

[AdRock]

I need help with how to create a relation between 2 tables using a third table as a relation between the 2.

 

Here is an example of what I have to do

 

Table 1

--------

cust_id  int(2) primary key

name    varchar (20) not null

age      int(2)

 

Table 2

--------

ord_id    int(2) primary key

desc      varchar(50) not null

qty        int(2)

 

Table 3

--------

custid    int(2) not null

ordid      int(2) not null

primary_key (custid, ordid)

 

 

 

I need to be able to select from both tables e.g. select * from table 1 where table 2.ordid=1

 

I have tried something like this but it doesn't work properly.  It just lists all in table 1

 

[Barand]

select * from table1

INNER JOIN table3 ON table1.cust_id = table3.custid

where table3.ordid=1